Categorize and count suppliers based on their average lead t…

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 passengers were in each boarding group? In the re…

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.