Basic SQL Syntax

Question 1

ALTER TABLE

Answer 1

ALTER TABLE table_name

ADD column_name datatype;

Question 2

AND

Answer 2

SELECT column_name(s)
FROM table_name
WHERE column_1 = value_1
  AND column_2 = value_2;

Question 3

AS

Answer 3

SELECT column_name AS ‘Alias’

FROM table_name;

Question 4

AVG()

Answer 4

SELECT AVG(column_name)
FROM table_name;

Question 5

BETWEEN

Answer 5

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value_1 AND value_2;

Question 6

CASE

Answer 6

SELECT column_name,
  CASE
    WHEN condition THEN 'Result_1'
    WHEN condition THEN 'Result_2'
    ELSE 'Result_3'
  END
FROM table_name;

Question 7

COUNT()

Answer 7

SELECT COUNT(column_name)
FROM table_name;

Question 8

CREATE TABLE

Answer 8

CREATE TABLE table_name (
  column_1 datatype, 
  column_2 datatype, 
  column_3 datatype
);

Question 9

DELETE

Answer 9

DELETE FROM table_name

WHERE some_column = some_value;

Question 10

GROUP BY

Answer 10

SELECT column_name, COUNT(*)
FROM table_name
GROUP BY column_name;

Question 11

HAVING

Answer 11

SELECT column_name, COUNT()
FROM table_name
GROUP BY column_name
HAVING COUNT() > value;

Question 12

INNER JOIN

Answer 12

SELECT column_name(s)
FROM table_1
JOIN table_2
ON table_1.column_name = table_2.column_name;

Question 13

INSERT

Answer 13

INSERT INTO table_name (column_1, column_2, column_3)

VALUES (value_1, ‘value_2’, value_3);

Question 14

IS NULL and IS NOT NULL

Answer 14

SELECT column_name(s)
FROM table_name
WHERE column_name IS NULL;

Question 15

LIKE

Answer 15

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;

Question 16

LIMIT

Answer 16

SELECT column_name(s)
FROM table_name
LIMIT number;

Question 17

MAX()

Answer 17

SELECT MAX(column_name)
FROM table_name;

Question 18

MIN()

Answer 18

SELECT MIN(column_name)
FROM table_name;

Question 19

OR

Answer 19

SELECT column_name
FROM table_name
WHERE column_name = value_1
OR column_name = value_2;

Question 20

ORDER BY

Answer 20

SELECT column_name
FROM table_name
ORDER BY column_name ASC | DESC;

Question 21

OUTER JOIN

Answer 21

SELECT column_name(s)
FROM table_1
LEFT JOIN table_2
ON table_1.column_name = table_2.column_name;

Question 22

ROUND()

Answer 22

SELECT ROUND(column_name, integer)
FROM table_name;

Question 23

SELECT

Answer 23

SELECT column_name

FROM table_name;

Question 24

SELECT DISTINCT

Answer 24

SELECT DISTINCT column_name

FROM table_name;

Question 25

SUM()

Answer 25

SELECT SUM(column_name)
FROM table_name;

Question 26

UPDATE

Answer 26

UPDATE table_name
SET some_column = some_value
WHERE some_column = some_value;

Question 27

WHERE

Answer 27

SELECT column_name(s)
FROM table_name
WHERE column_name operator value;

Question 28

WITH

Answer 28

WITH temporary_name AS (
   SELECT *
   FROM table_name)
SELECT *
FROM temporary_name
WHERE column_name operator value;