We will be breaking up into groups to solve a problem together which should help you for the final project. Work with your group to solve the following problem.

$1.$ Create SQL code to create all the tables including primary and foreign keys

$2.$ Create $3$ queries and one must include a join. Some ideas include:

A query to find all items that cost more than $$10.$

A query to find all items with a name that begins with $\text{'}$S$\text{'}$

A query to find the average number of items on hand

A query to find all items with low inventory

A query to find all items in the Central region

All suppliers from the North region

All items supplied by Wallflower

These are just some examples $-$ feel free to create any queries you would like.$$

The tables are below: