FILTERING DATA

Question 1

WHERE

Answer 1

Keyword for condition used for filtering.

SELECT column
FROM data
WHERE column = 1;

Question 2

=

Answer 2

Used when 2 values are equal or to pick a specific value

SELECT column
FROM data
WHERE column = 1;

Question 3

‘ ‘

Answer 3

Quotes are used when writhing a text value

SELECT colour
FROM data
WHERE colour = ‘black’;

Question 4

<>

Answer 4

Selects data that doesn’t satisfy a condition or not equal to

SELECT colour
FROM data
WHERE colour <> ‘black’;

Question 5

<

Answer 5

Less that operator

SELECT number
FROM data
WHERE number < 5;

Question 6

>

Answer 6

Greater that operator

SELECT number
FROM data
WHERE number > 5;

Question 7

<=

Answer 7

Less that or equal to

SELECT number
FROM data
WHERE number <= 5;

Question 8

>=

Answer 8

Greater that or equal to

SELECT number
FROM data
WHERE number >= 5;

Question 9

BETWEEN

Answer 9

Keyword to check property within range.

SELECT *
FROM movies
WHERE rating BETWEEN 9 AND 10;

Question 10

AND

Answer 10

Keyword used to define a range.

SELECT *
FROM movies
WHERE rating BETWEEN 9 AND 10;

Question 11

LIKE

Answer 11

Keyword to filter out by pattern within text values

SELECT*
FROM movies
WHERE action LIKE ‘a%’ ;

Question 12

%

Answer 12

It helps you define what latter/words starts, end and words in between a sentence or letter. If left on it own it gives all the data in a selected column

SELECT*
FROM movies
WHERE action LIKE ’a%’;