Complete the following exercise:

Using the tables, you created and populated with sample data from Week $8$ write SQL queries to answer the following questions. Bear in mind that you may make changes to your tables and queries as you work your way through this case study to completion.

Here are the SQL queries you are to create:

List the names of the customers who provided bids last month.

List all the customers that have an outstanding balance $($amount due to Bob$)$ that is greater than $$500.$

List all the suppliers where Bob has an outstanding balance that is greater than $$1,000.$

List all the material that was used for bids where the estimated hours for the bid was greater than $40$ hours.

List all the material that Bob purchased from a specific supplier $($Note: you can decide on the supplier but there should only be one supplier$).$

Once you have completed all your DML $($select commands$)$ copy and paste your script into a Word document and submit it to the link above.