functions

Question 1

COUNT

Answer 1

takes one argument. Returns the number of rows matching the SELECTion

Question 2

SUM

Answer 2

takes a colunm as argument, returns sum of all values in that column

Question 3

MAX

Answer 3

retuns the row that has the greatest value of argument c1

Question 4

MIN

Answer 4

returns the row that has the smallest value of argument c1

Question 5

AVG

Answer 5

takes a column name and returns the average value of that column

Question 6

ROUND

Answer 6

first argument, value to round, second, number of decimal places to round to (ie 0 is whole number)