Free Printable SQLite - Writing Queries

Worksheets

SQLite - Writing Queries

Total questions: 9

Worksheet time: 8mins

Name

Class

Date

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

Write the SQL command that will return all information from movies that have genre of romances and 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;

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

NULL

Return 2 movies where the movie name 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;

Which of the following code is written correctly?

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 WHERE genre = ‘horror’;

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

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

The asterisk doesn’t need to be there

The equal sign needs to go before genre

There needs to be an underscore in between imdb and rating

The single quotes don’t need to be there

SQLite is a _____

NoSQL database

Distributed database

Relational database

Operational database

SQLite is case insensitive.

TRUE

FALSE

Which of the following will be returned if the query is:

SELECT * from Customer

where CustFName LIKE ‘Ta_g%';

Tung

Tammg

Tang

Tarngie

Reset

SQLite - Writing Queries

Total questions: 9

Worksheet time: 8mins

Similar Resources on Wayground