CREATE DATABASE COLONIAL; USE COLONIAL; CREATE TABLE Guide (GuideNum CHAR(4) PRIMARY KEY, LastName CHAR(15), FirstName CHAR(15), Address CHAR(25),

I have attached the following MySQL Files for the TAL Database and the COL Database. I need some help in creating the appropriate SQL Statements for the following questions:

USE TALSQL.txt for the following questions:

12. List the item number, description, and category for each pair of items that are in the same category. (Example: One such pair would be item CD33 and item DL51, because the category for both items is TOY)

14. List the order number and order date for each order that contains an order line for a Fire Engine.

18. List the item number, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category GME. Use either the ALL or ANY operator in your query. (Hint: Make sure you select the correct operator)

Use the COLSQL.txt for the following questions:

4. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide.

6. List the reservation ID, Trip ID, and trip date for reservations for a trip in Maine (ME). Use the IN operator in your query.

12. List the number and name of each customer that either lives in the state of New Jersey (NJ), or that currently has a reservation, or both.

14. Find the trip ID and trip name for each trip whose maximum group size is greater than the maximum group size of every trip that has the type 'Hiking'

16. Display the Trip ID, trip name, and reservation ID for all trips. All trips should be included in the result. For those trips that currently do not have reservations, the reservation ID should be left blank. Order the results by trip ID.

• Attachment 1
• Attachment 2