COUNT, SUM, and AVG

Question 1

What do SELECT COUNT statements do?

Answer 1

count the number of rows that appear in a database table

Question 2

What is the basic SELECT COUNT statement format?

Answer 2

SELECT COUNT(*) FROM table_name;

Question 3

How is the combination of SELECT COUNT and WHERE used?

Answer 3

to count how many rows meet a certain criteria

Question 4

How is the combination of SELECT COUNT and GROUP BY used?

Answer 4

to count how many row meet each option in the column

Question 5

What do SUM statements do?

Answer 5

add all values in a particular column

Question 6

What is the basic SUM statement format?

Answer 6

SELECT SUM(column_name) FROM table_name;

Question 7

What do MAX statements do?

Answer 7

find the largest value in a column

Question 8

What is the basic MAX statement format?

Answer 8

SELECT MAX(column_name) FROM table_name;

Question 9

What do MIN statements do?

Answer 9

find the smallest value in a column

Question 10

What is the basic MIN statement format?

Answer 10

SELECT MIN(column_name) FROM table_name;

Question 11

What do AVG statements do?

Answer 11

find the average value in a column

Question 12

What is the basic AVG statement format?

Answer 12

SELECT AVG(column_name) FROM table_name;

Question 13

What do ROUND statements do?

Answer 13

round the values in a column to a certain number of decimal places

Question 14

What is the basic ROUND statement format?

Answer 14

ROUND(CONDITION(condition column_name), number_of_decimal_places, FROM table_name;