SQL Practice Quiz: Chunk 2

Test your knowledge of the WHERE clause and data filtering.

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

You must use the exact capitalisation for the tables below. Do not use lowercase!

In SQL, we only use a SINGLE equals sign (=). Do not use ==.
Text strings MUST have single quotation marks around them (e.g. 'Sci-Fi').
Table names are case-sensitive! You must type exactly what is listed in the blue box above.

Section 1: Spot the Error

Read the broken queries below and type the CORRECTED version.

StudentID (Int)	FirstName (Text)	LastName (Text)	Subject (Text)	Age (Int)

Write the exact SQL code needed to achieve the plain-English tasks.

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

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

NAME NOT LOCKED YET

0 / 16 correctly finished