SQL Practice Quiz: Chunk 3 (Extended)

Mastering Compound Conditions: 20 Questions to test your AND/OR logic.

Please enter your name to begin. Once locked, it cannot be changed.

Ensure your capitalisation matches exactly:

AND narrows down results (both sides must be true).
OR expands results (only one side needs to be true).
You must restate the field name for every condition! (e.g., Rating = 9 OR Rating = 10, NOT Rating = 9 OR 10).
Remember to use single quotes for text, and no quotes for numbers!

Section 1: Narrowing Data (The AND Operator)

FilmID (Int)	Title (Text)	Director (Text)	Genre (Text)	ReleaseYear (Int)	Rating (Int)

GameID (Int)	Title (Text)	Platform (Text)	Genre (Text)	Price (Int)	Multiplayer (Text)

BookID (Int)	Title (Text)	Author (Text)	Genre (Text)	PublicationYear (Int)

Read the broken queries below and type the fully corrected versions. Pay attention to syntax, quotation marks, and complete compound conditions.

ActID (Int)	Stage (Text)	Day (Text)	SetLength (Float)

NAME NOT LOCKED YET

0 / 20 correctly finished