and yeah the curation of the trip is time, but there is a start station code and an end station code for where the bikes were picked up and where...

Ah yeah, I missed, there is an end_station_code as well,

Haha, of course, ok so I got this so far: 

CREATE VIEW stationtriplength AS
SELECT trips.start_station_code, trips.duration_sec, stations.name
FROM trips JOIN stations ON trips.start_station_code = stations.code 

Sorry for all the questions, this should be the last one: I have the date in the DATETIME format and the question asked me to find the average trip length...

The Last_day function worked! And yeah my bad, I had to use CAST as well. Thank you guys so much, it worked!

SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'decimal(9,1),COUNT(*)/(DAY(EOMONTH(start_date))+0.0)) AverageTripsPerDay

Jonathan AC -- it keeps giving me a syntax error

If I had to calculate the average number of trips per day for each yeah-month combination, would I add to the above query or does it have to be separate...

Ahhh ok, thank you so much!