Question 1:

Write a select statement to create the inner join of tables sec1310_table1 and sec1310_table2. The join condition should say that the first three columns of these tables are equal.

 

Question 2:

A large dictionary has four volumes. Table sec1311_dictionary shows the range of words that are in each volume. Table sec1311_words contains some words that are in the dictionary. Write SQL to determine which volume of the dictionary contains each of these words.

 

 

Question 3:

Tables sec1313_words1 and sec1313_words2 contains words. Join these tables together when the words end in the same letter.

 

Question 4:

Write a select statement to list all the foods on the lunch menu and show the full name of the supplier of each food.

 

Question 5:

List all the foods on the menu and the total number of orders for each food item. (Note that broccoli does not show up in the result because no one has ordered it.