Describe the query you would run to determine which customers have placed an order but still haven't paid. What values from each table need to be used?

Describe the query you would run to determine how many customers on the mailing list have placed orders. What values from each table need to be used?

Now put yourself in the shoes of the bakery manager.

Think of two other scenarios you would encounter in your job and how you would use the database to help you.

For each scenario, describe how you would use the database to help you. Provide the following:

Describe the scenario you have come up with.

What values would you need and what tables are those values found in$?$

Are there any other steps you need to complete to provide the information needed?

Your answers should be written as a summary in paragraph form.