Find the 'most popular' bike, i.e. the bike that has made the highest number of trips (1.5 pts)2. Find the number of trips made by each subscription type. (1.5 pts)3. Build a table that shows which...

Find the 'most popular' bike, i.e. the bike that has made the highest number of trips (1.5 pts)2. Find the number of trips made by each subscription type. (1.5 pts)3. Build a table that shows which stations are connected, and the minimum duration between them. You can use either station id or station name. Save this table as a comma separated text file in ‘/user/assignment1/stationlist.csv’ in HDFS. Include the directory listing of the output directory and first five lines of the output file in your submission. (3 pts)4. Find the number of trips originating from each landmark. Your output should include the landmark name and the number of trip originating from it. (3 pts)5. Find the number of trips crossing landmarks, i.e. trips that originate in one landmark and end in another. Your output should include the originating and ending landmark names and the number of trips between them. (6 pts)