1

Question 1

Start of every statemtn

Answer 1

SELECT

Question 2

Reference a database table

Answer 2

FROM

Question 3

Produce 10 rows

Answer 3

LIMIT 10

Question 4

Number of user id (no repeat)

Answer 4

COUNT( DISTINCT user_id)

Question 5

equal, not equal, less than/equal, great than/equal

Answer 5

= <> != <= =>

Question 6

Condition statement specific date

Answer 6

WHERE date = ‘2022-01-25’

Question 7

More condition statements

Answer 7

AND

Question 8

Alternative condition statement

Answer 8

OR

Question 9

Instead of writing OR device_id = 2 OR device_id = 3 could write

Answer 9

Device_id IN (2,3)

Question 10

Return true if value is null

Answer 10

IS NULL

Question 11

Return a word with second letter r

Answer 11

_r%

Question 12

Aggregate functions

Answer 12

SUM, MAX, MIN, AVG

Question 13

Rename column name

Answer 13

AS

Question 14

Change type

Answer 14

CAST(price AS FLOAT)

Question 15

Make sure returns to 1dp

Answer 15

/100.0

Question 16

Make Revenue go from highest to lowest

Answer 16

ORDER BY revenue DESC (or ASC)

Question 17

Put all product ids together to look at number sold for each

Answer 17

GROUP BY product

Question 18

When an aggregate function use instead of where clause

Answer 18

HAVING AVG(budget) >0

Question 19

Call the database a different name

Answer 19

Replicated_datawarehouse.THG.Customer c