Write a code for the following: Return all romances that have an imdb_rating over 6.

SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;

SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;

SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;

SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;

Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.

SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;

SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;

SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;

SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;

Which of the following code is written correctly?

SELECT * FROM movies WHERE genre = ‘horror’;

SELECT * FROM movies WHERE imdb_rating is 1 AND ORDER by desc;

SELECT * FROM movies WHERE genre = ‘comedy’ AND ORDER BY ASC LIMIT 1:

SELECT * FROM movies genre is horror, and rating is 2;

Write the code for the following: Return all movies made before 2011 and order by the imdb rating from highest to lowest.

SELECT * FROM movies WHERE year < 2011 ORDER BY imdb_rating DESC;

RETURN * FROM movies WHERE year < 2011 AND imdb_rating ASC;

SELECT * FROM movies WHERE year > 2011 ORDER BY imdb_rating DESC;

SELECT * FROM movies WHERE year = 2011 ORDER BY imdb_rating ASC;

What is wrong with the following code: SELECT * FROM movies WHERE genre = comedy AND year < 2016 ORDER BY year DESC;

Comedy should have single quotes around it

Match the following SQL term with a description - FROM

The field and order used to sort the results

Match the following SQL term with a description - SELECT

The field and order used to sort the results

Match the following SQL term with a description - WHERE

The field and order used to sort the results

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

SQL Quiz: 30 Practice Questions (Grade 5)

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

FROM

WHERE

SELECT

ORDER BY

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of *?

Selects ALL fields from the table

Selects only the first field in the table

Selects the last field in the table

Shows only the first row in the table

3.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

You must always use _____ when using text values

quotes

astericks

exclamation point

percent signs

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct order of clauses?

SELECT, FROM, ORDER BY, WHERE

SELECT, FROM, WHERE, ORDER BY

SELECT, WHERE, FROM, ORDER BY

WHERE, FROM, SELECT, ORDER BY

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Use what to separate multiple table names in the FROM clause?

commas

periods

spaces

semicolons

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which clause allows you to SORT data?

ORDER BY

WHERE

FROM

HAVING

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Use which clause to FILTER data?

WHERE

ORDER BY

FROM

HAVING

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

25 questions

S/E Asia Government and Economies

Quiz

•

5th - 7th Grade

28 questions

Occ69 Setting out

Quiz

•

KG - University

25 questions

Chess For Beginners

Quiz

•

KG - 6th Grade

30 questions

Pre-Civil War

Quiz

•

5th Grade

30 questions

Elements, Compounds, Chemical Formulas and Equations

Quiz

•

5th - 8th Grade

26 questions

Friday Prayer and Prayer of the Two Feasts

Quiz

•

5th Grade

27 questions

Are you smarter than a 5th grader? #1

Quiz

•

3rd - 6th Grade

25 questions

Game Tebak Lagu

Quiz

•

KG - Professional Dev...

Popular Resources on Wayground

10 questions

Safety Day 2026 – Student Review

Quiz

•

9th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

Discover more resources for Other

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

10 questions

Columbus Day and Indigenous People's Day

Interactive video

•

5th - 8th Grade

20 questions

Mixtures and Solutions Practice

Quiz

•

5th Grade

15 questions

Mastering Multiplication Facts 1-10

Quiz

•

5th Grade

SQL