SQL Programming Advanced Quiz 4

1. Write a SQL query to find the maximum value in column "score".

2. Write a SQL query to select the first 5 rows ordered by "date" descending.

3. Explain common SQL data types. Which are most used?

4. What is the purpose of GROUP BY? Write a query grouping sales by product.

5. Write a SQL query to find the average salary per department.

6. Write a SQL query to select all records except those with "country" = "USA".

7. Write a SQL query to select all records where "name" ends with "son".

8. Write a SQL query to count the number of unique cities in "clients".

9. What is a trigger? Write a trigger to update "LastUpdated" timestamp on record modification.

10. Write a SQL query to find employees hired after 2020-01-01.