Free Printable SQL - sys vars & filters

Worksheets

SQL - sys vars & filters

Total questions: 22

Worksheet time: 15mins

Name

Class

Date

If you were wanting to filter data, which clause would you use?

Where

Order by

From

Select

Using which word allows you to specify that more than one condition must be met in a query?

Also

And

Where

Less than or equal to?

Which character returns all the data found in a table?

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

COUNT(*)

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

ASC

DESC

There is no default value

None of the mentioned

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’%a%’

SQL query to find all the cities whose humidity is 95.

SELECT city WHERE humidity = 95

SELECT city FROM weather WHERE humidity = 95

SELECT humidity = 89 FROM weather

SELECT city FROM weather

10.

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

11.

DDL means

(a)

12.

DML

(a)

13.

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;

14.

Which Symbol means "All"

15.

What will be the output?

SELECT ROUND(36.7894,2)

36.78

38.79

36.7

16.

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

NULL

17.

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;

18.

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;

19.

SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7 LIMIT 8; ORDER BY ASC LIMIT 8;

SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7 LIMIT 8;

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

SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7;

20.

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

AND should be lower case

movies should be capitalized

No changes should be made

21.

Write the code for the following: Return all movies containing the word 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%’;

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

22.

Which of these groups are in the six common operators?

#=, ^=, $=

=, !=, >=

>^, <>, =+

<+>, >=<, (<)

Reset

SQL - sys vars & filters

Total questions: 22

Worksheet time: 15mins

Similar Resources on Wayground