Database programming section 8 quiz

What two group functions can be used with any datatype?
You can use AVG, SUM.
MIN, and MAX functions against columns that can store numeric data.
The example on the slide displays the average, highest, lowest, and sum of monthly salaries for all salespeople.
You can use MIN and MAX for any datatype..
Which aggregate function can be used on a column of the date data type?
You can use the date and time data types with the MIN() , MAX() , COUNT() functions, the DISTINCT argument to those functions, and the GROUP BY argument to the SELECT() function.
An attempt to use SUM() or AVG() with date or time data types returns an error..
Which SELECT statement will count the number of rows in the products table?
SQL SELECT COUNT(*) function
SQL SELECT statement can be used along with COUNT(*) function to count and display the data values.
The COUNT(*) function represents the count of all rows present in the table (including the NULL and NON-NULL values)..

What two group functions can be used with any datatype?