which denotes any single character, is next

General structure of functions is KEYWORD (ARG1, ARG2, ARG3).

search will return the lower-case version

SUBSTR() : Trimming white space off each side of a string

Takes the string we hand it in parentheses and returns a part of the string.

Update all row to trim spaces in the ‘state’ field

Concatenate operator

How many distinct ZIP Codes, for instance, are there in the table?

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