SQL Filtering Mastery
Connect your logic to your data using the WHERE clause. Master string comparisons, numerical operators, and case-sensitive table names.
Identity Verification
The Golden Rules
- Use a single equals sign (=). No double ==.
- Strings must have single quotes ('Sci-Fi').
- Table names are case-sensitive (e.g. tblStudents).
- Columns with no quotes: numbers (16).
Section 1: Spot the Logic Errors
Section 2: The Books Database
| BookID (Int) | Title (Text) | Author (Text) | Genre (Text) | PublicationYear (Int) | AvailableCopies (Int) |
|---|
Section 3: Films & Consolidation
| FilmID (Int) | Title (Text) | Director (Text) | Genre (Text) | ReleaseYear (Int) | Rating (Int) |
|---|
Identity Not Verified
0 / 16
Mastery Level Established