SQL commands

Question 1

SELECT

Answer 1

Query info from a database

Question 2

AS

Answer 2

rename column or table

Question 3

DISTINCT

Answer 3

return unique values

Question 4

WHERE

Answer 4

filter results based on specified condition

Question 5

LIKE

Answer 5

use with WHERE
match closely matching names using wildcard characters

Question 6

BETWEEN

Answer 6

use with WHERE
return results within a range.
Numbers: includes 2nd condition
Text: includes first specified character in 2nd condition

Question 7

AND

Answer 7

use with WHERE
meets all conditions

Question 8

OR

Answer 8

use with WHERE
meets any condition

Question 9

ORDER BY

Answer 9

sorts results
ASC: default
DESC: high to low, Z-A

Question 10

LIMIT

Answer 10

specifies number of rows to return
always at end of query

Question 11

CASE

Answer 11

if-then conditional
CASE
WHEN … THEN …
ELSE …
END

Question 12

CREATE TABLE

Answer 12

creates a new table

Question 13

INSERT INTO

Answer 13

adds a new row to a table

Question 14

ALTER TABLE

Answer 14

edits table column(s)

Question 15

UPDATE

Answer 15

edits table row(s)

Question 16

DELETE FROM

Answer 16

deletes rows from a table

Question 17

Constraints

Answer 17

specifies how column can be used
eg. data types

Question 18

COUNT()

Answer 18

count the number of rows

Question 19

SUM()T

Answer 19

sum of the values in a column

Question 20

MAX() /
MIN()

Answer 20

the largest / smallest value

Question 21

AVG()

Answer 21

the average of the values in a column

Question 22

ROUND()

Answer 22

round the values in a column

Question 23

GROUP BY

Answer 23

used with select to arrange identical data into groups
WHERE
GROUP BY
ORDER BY
LIMIT

Question 24

HAVING

Answer 24

use to filter groups
GROUP BY
HAVING
ORDER BY
LIMIT