What is the average number of available rooms in each hotel? SELECT ROUND(AVG(rooms_available), 1) AS avg_available_roomsFROM hotels; Enter the value.

How many hotel bookings were there by month? SELECT     MONTH(checkin_date) AS month_number,    COUNT(*) AS total_bookingsFROM bookingsGROUP BY MONTH(checkin_date)ORDER BY month_number; Upload a well-formatted line chart.

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.