What is a surrogate Key ?

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

How do you select every row in a given table named "inventory"?

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?