Return 5 movies with an imdb rating of 7 or higher.

SELECT * FROM movies WHERE imdb_rating >= 7 LIMIT 5;

SELECT * FROM movies WHERE imdb_rating = 7 limit 5;

SELECT * FROM movies WHERE imdb-rating >= 7 LIMIT 5;

SELECT * FROM movies WHERE imdb_rating <= 7 LIMIT 5;

Return 8 romances that were made before 1999.

SELECT * FROM movies WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;

SELECT * FROM movies WHERE genre = romance AND year > 1999 LIMIT 8;

SELECT * FROM games WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;

SELECT * FROM Movies WHERE genre = ‘romance’ AND year > 1999 LIMIT 8;

Write the code for the following : Return all movies with the word love.

SELECT * FROM movies WHERE name LIKE ‘%love%’;

SELECT * FROM movies WHERE name LIKE %love%;

SELECT * FROM movies WHERE name LIKE ‘love’;

SELECT * FROM movies WHERE name LIKE %love;

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

Return 5 movies that have an imdb rating greater than 4 and are comedies.

SELECT * FROM movies WHERE imdb_rating > 4 AND genre = ‘comedy’ LIMIT 5;

SELECT ALL FROM movies WHERE imdb_rating < 4 AND genre = ‘comedy’ LIMIT 5;

SELECT * FROM movies WHERE imdb rating > 4 AND genre = comedy LIMIT 5;

SELECT ALL FROM movies WHERE imdb_rating > 4 AND genre = ‘comedy’;

What is wrong with the following code: SELECT * FROM movies WHERE genre = ‘romance’ AND imdb rating > 8;

There needs to be an underscore in between imdb and rating

The asterisk doesn’t need to be there

The equal sign needs to go before genre

The single quotes don’t need to be there

Write the code for the following: Return all movies containing the word iron.

SELECT * FROM movies WHERE name LIKE ‘%iron%’;

SELECT * FROM i am a beast 1,2,3 WHERE name LIKE ‘%iron%’;

SELECT * FROM movies WHERE name LIKE ‘%iron%’

SELECT FROM movies WHERE name LIKE ‘%iron%’;

What does * mean when writing code?

Select jaskfjfjfjsfjiosjisjfjsfjsfjkjsk

Write the code for the following: Search the unique genres located in movies table.

SELECT DISTINCT genre FROM movies;

SELECT DISTINCT genre from movies;

SELECT DISTINCT genres FROM movies;

SQL Queries

Authored by B H

Other

9th - 12th Grade

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

24 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.

SELECT * FROM movies WHERE name LIKE ‘day’;

RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;

ANSWER: SELECT * FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Return all dramas made after 2004.

SELECT * FROM movies WHERE genre = 'drama';

SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;

SELECT * FROM movies WHERE genre = "drama' AND year < 2004;

SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 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;

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

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is a special value in SQL that represents missing or unknown data?

NULL

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Return 2 movies with that include the word power.

SELECT * FROM movies WHERE name = ‘%power%’ LIMIT 2;

SELECT * FROM movies WHERE genre LIKE ‘%power%’ LIMIT 2;

SELECT * FROM movies WHERE name LIKE ‘%power%’ LIMIT 2;

SELECT * FROM games WHERE name LIKE ‘%power%’ LIMIT 2;

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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Popular Resources on Wayground

10 questions

5.P.1.3 Distance/Time Graphs

Quiz

•

5th Grade

10 questions

Fire Drill

Quiz

•

2nd - 5th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

22 questions

School Wide Vocab Group 1 Master

Quiz

•

6th - 8th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

12 questions

What makes Nebraska's government unique?

Quiz

•

4th - 5th Grade

Discover more resources for Other

10 questions

Cell Organelles and Their Functions

Interactive video

•

6th - 10th Grade

20 questions

Graphing Inequalities on a Number Line

Quiz

•

6th - 9th Grade

18 questions

Informative or Argumentative essay

Quiz

•

5th Grade - University

20 questions

Figurative Language Review

Quiz

•

10th Grade

20 questions

Exponential Functions Key Features

Quiz

•

9th Grade

14 questions

Ecological Succession: Primary and Secondary

Quiz

•

9th Grade

20 questions

Career

Quiz

•

9th - 12th Grade

11 questions

Adding and Subtracting Polynomials

Quiz

•

9th Grade