question

Andydba avatar image
Andydba asked

Can someone help me determining the script for #3 about the most frequent trip.

f91410bf-d54c-4b75-adf7-7adda9b64292.jpeg

sqlt-sqlsql server 2012functions
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WRBI avatar image
WRBI answered

Don't know if I'm going crazy or it's because I've just come back from a holiday.

But, if you want to calculate the number of Trips between two stations you'd need a StartStationId and an EndStationID. Unless I'm missing something completely obvious about the data model?

Sorry for the answer, I would have liked to comment but there's and issue with them and they're being being fixed.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.