Blog

How many available rooms do we have across all hotels? SELECT SUM(rooms_available) AS total_available_roomsFROM hotels; Enter the count.

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

What was the average nightly rate? SELECT ROUND(AVG(price_per_night), 2) AS avg_nightly_rate,FROM bookings; Enter the value.

Submit Work

How many suppliers do we have? Enter the count.

How many suppliers do we have by location type? Enter those counts.   [a]  local [b]  national

Categorize and count suppliers based on their average lead time. Use CASE WHEN to accomplish this. Suppliers with a lead time less than or equal to 3 days are “faster”, others are “slower”. Then, split the categories by location type (local and national). Enter those counts.   [a]  local – faster [b]  local – slower [c]  national – faster [d]  national – slower

How many purchases were made? Enter the count.

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.

Respond to the Business Leader