Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates will provide answers based on the requirements.

1-Find all products inventory to be distributed by a distributor named Empire and shipped by a shipper named RunQuick. In the list return have the names of the distributor and shipper displayed, not just the IDs.

2-Find all products in inventory to be shipped by FlightFast that costs more than $50

3-Return all products from a distributor named Dutchess, grouped by their shipper.

2)Write descriptions for two modifications for data already in the database.

1-A distributor has relocated from Beacon, NY to Green Bay, WI. Update this.

2-Sloop has changed the name of the beer called Juice Bomb to Atomic Blast. Reflect this.

3)Write descriptions for two deletions for data already in the database.

1-Delete the Beer called Confliction.

2-Delete the Distributor named Empire.

Write DML statements for each query and post them as replies to your classmates. Do not use a query generator or graphical tool to write these; write them on your own and test them in your chosen DBMS before posting.