How many hotels do we have? SELECT COUNT(*) AS num_hotelsFROM hotels; Enter the count.

What was the average unit cost for each ingredient? For example, what was the average cost for each pound of bell peppers? Sort the results by ingredient in alphabetical order. Round to two decimal places. Enter the unit cost for the ingredients below.   [a]  avocado [b]  basil

Write Queries

Categorize and count ingredients based on their unit cost. Use CASE WHEN to accomplish this. Ingredients should be categorized into these groups: low cost — less than or equal to $1 medium cost — less than or equal to $2, but greater than $1 high cost — greater than $2 (Round to two decimal places.) Enter the counts for each category.   [a]  low cost [b]  medium cost [c]  high cost

How much did we pay for ingredients by supplier location type? Enter those values.   [a]  local [b]  national

How many purchases were made? Enter the count.

Categorize and count flights by their length of delay. Use CASE WHEN to create these categories: no delay — less than or equal to 0 short delay — greater than 0, but less than 30 moderate delay — greater than or equal to 30, but less than 60 long delay — greater than or equal to 60 Enter the counts in each category.   [a]  1.  no delay [b]  2.  short delay [c]  3.  moderate delay [d]  4.  long delay

Which passengers experienced the most flight delays? For each passenger, count their number of delayed flights and total minutes of delay. Include the passenger’s full name using this format: “Last Name, First Name”. Only count flights with a delay greater than 0. Use a common table expression to accomplish this. Select the two customers with the most delayed flights.

How many passengers were in each boarding group? In the results, show the # of passengers and % of total passengers in the boarding group. Use a window function to accomplish this. Remove the blank spaces in the boarding group. Select the two busiest boarding groups.

Based on your query results, respond to the business leader. This is an open-ended question. There is not necessarily one right answer. It requires a thoughtful, coherent response. There is no minimum or maximum length. (Brevity is ideal, assuming the questions are answered.) It should include key insights from the query results that support your response. You may consider additional queries (beyond those above) to improve your response. You may also consider outside research or comparisons, but it must be from a reliable source.