SQL Quiz

What does this SQL query do?

SELECT * FROM customers;

• Delete all customer's data

• Update all customers to be called *

• Find all data held about all customers.

• Delete the customers table.

Which statements are true about this SQL query?

DELETE FROM customers WHERE id=8;

• Data is deleted from the customers table.

• Data in the customers table is edited.

• Only customer with id number 8 is effected.

• All customers are effected.

What word is missing from this query to remove the customers table.

................ TABLE customers;

What word is missing from this table to select all customers from the Jones family.

SELECT * FROM customers .............. family="Jones";

What does this query do?

SELECT shop.name FROM shops INNER JOIN staff ON staff.shop = shop.id WHERE staff.name="John Smith";

• Identify the name of the shop where John Smith works.

• Assign John Smith to work at a specific shop.

• List the staff who work at all shops.

What is the missing word in this query to show how many staff work at each shop?

SELECT COUNT(id) FROM staff .............BY shop;

Write an SQL query to delete all data from the staff table.

Write an SQL query to remove the staff table completely.

Fill in the blank for this query to find John Smith's email address:

............... email FROM staff WHERE name="John Smith";

Write an SQL query to rename the 'staff' table to 'employees'.