Skip to content

Latest commit

 

History

History
8 lines (5 loc) · 651 Bytes

File metadata and controls

8 lines (5 loc) · 651 Bytes

Assignment 3 - Problem Solving by SQL

Task 1: Find the total number of searches for each room type (apartments, private, shared) by city.

Task details: https://platform.stratascratch.com/coding/9638-total-searches-for-rooms?code_type=1

Task 2: You’re given a table of Uber rides that contains the mileage and the purpose for the business expense. You’re asked to find business purposes that generate the most miles driven for passengers that use Uber for their business transportation. Find the top 3 business purpose categories by total mileage.

Task details: https://platform.stratascratch.com/coding/10169-highest-total-miles?code_type=1