How can you do an UPDATE?

HAVING clause is used in combination with _____.

The correct way to average all of the values from a column 'values' from table 'foo' is

How to write a query to select all orders that contain either 3, 5, 7 or 9 items?

Assume, you have two tables company (id int, name text) and employee(id int, company int, name text). How would you select all employee names and their corresponding company names, e.g. John, Microsoft Mary, IBM Jane, Oracle

A table may be joined to itself.

What is the difference between DROP and TRUNCATE?

How can you filter duplicate data while retrieving records from a table?

You are working with very large tables in your database. Which SQL clause do you use to prevent exceedingly large query results?

A trigger is a database object that is associated with a table, and that activates when a particular event occurs for the table. Which three events are these?

If you need to order a table of movies by name, which query will work?