Hive Bike Share Assignment Passed
1. Utilizing the Bay Area Bike Share database (both Year 1 & 2, Aug. 2013- Aug. 2015)- what is the most popular start station based on trip data? Embarcadero at Sansome Market at 4th San Francisco Caltrain Townsend at 7th -- Run this in HIVE Editor -- SELECT startterminal, startstation, COUNT(1) AS count FROM bay_area_bike_share GROUP BY startterminal, startstation ORDER BY count DESC LIMIT 10 2. Utilizing the Bay Area Bike Share database (Year 1 only, Aug. 2013- Feb 2014) - Which is the least popular(least used) start station in the Bike share trips data? (Hint: Use the count of start station, group and order in ascending order) Townsend at 7th Mezes Park Market at 4th Embarcadero at Sansome -- Run this in HIVE Editor -- SELECT startstation, COUNT(1) AS count FROM bay_area_bike_share GROUP BY startstation ORDER BY count ASC LIMIT 10 3. Utilizing the Bay Area Bike Share database (for Year 1 on...
Comments
Post a Comment