What is the maximum amount that any of our contributors has given?

What is the total donors’ amount of contributions from Georgia?

What is the average amount contributed?

What if we were interested in learning who had given the largest amount? We then use …

SELECT id FROM contributors WHERE amount = (SELECT MAX(amount) FROM contributors

Select the total amount from each state

WHERE clause can use aggregate functions.

For aggregates, the equivalent of a WHERE clause is the HAVING clause. Immediately following the GROUP BY

.......... function is used to count the number of rows, but it counts all rows in a table including the rows with NULL values, whereas ............. counts only the non-NULL values in the specified column.

LIKE operator matchs a pattern ( case insensitive)

Which of the following should be used to find the mean of the salary?

Text requier double quotation mark

ALTER modifies table structure

to Retrieve all data from exam table

join on the tables is a query that merges the data from two different tables.

We can use Aliases instead of complete table name

We Can use Aliases also function with the JOIN keyword

The default form of JOIN

Return rows where there is a match in both tables