In-class exercise for Wednesday, October 26

Chilly weather is coming. You are generous person. Let's plan on giving sweaters and jackets to our friends and relatives.

Write a SQL script that:

• creates a table that has 2 columns
• one column holds the names of people
• one column holds the kinds of warm clothing
• create a second table that has 2 columns
• one column holds kinds of warm clothing
• one column holds prices
• fills the table with data
• you have at least 6 friends and relatives
• you are planning to give a sweater to some
• you are planning to give a jacket to some
• you are planning on giving a sweater and a jacket to some
• a query that produces a result with 3 columns
• person
• article of clothing
• price
• a query that produces a result with 2 columns
• person
• total cost of gifts for that person