AirBnB and BikeShare query challenges performed while learning PostgreSQL. Below I show the three of the harder challenges that I completed instead of listing all of the challenges that I completed. This questions are also questions that I feel would be business relevant in the real world.
- Return a list of stations with a count of number of trips starting at that station but ordered by dock count?
- What's the most expensive listing? What else can you tell me about the listing?
2. What neighborhoods seem to be the most popular?
3. What time of year is the cheapest time to go to San Fransisco? What about the busiest?