SQL Review Quiz

INSERT clause

WHERE clause

SELECT clause

DELETE clause

New tables

New cells

New columns

New rows

AVG(value)

MIN(value)

MAX(value)

SUM(value)

ALIAS

TITLE

AS

NAME

To provide more meaningful names

To make the query run faster

To delete duplicate data

To change the data type

To sort records

To group records with the same values

To delete records

To filter records

To rename columns or results

To rename tables

To join tables

To delete data

Counts the number of dates in the dateOrdered column

Finds the latest date in the dateOrdered column

Finds the earliest date in the dateOrdered column

Sums up all the dates in the dateOrdered column

Calculates the sum of values

Finds the maximum value

Finds the minimum value

Calculates the average of values

SELECT COUNT(NULL) FROM employees;

SELECT COUNT(DISTINCT employee_id) FROM employees;

SELECT COUNT(*) FROM employees;

SELECT COUNT(employee_id) FROM employees;