SQL Queries

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;

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%’;

A column in a database

• record
• row
• field
• data

• 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;

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

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;

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

• %
• ?
• NULL
• *

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;

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;