Click here to Skip to main content
15,029,958 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi! I'm new learner. And now I'm trying start diving into bigquery sql.
I have some study case and need help to solve.

I have table of interest
`bigquery-public-data.new_york_citibike.citibike_stations`
`bigquery-public-data.new_york_citibike.citibike_trips`

Questions are

1. How to find the oldest and youngest age for the subscriber for each gender?
2. Monthly growth of the trips by %
3. Get trips with start_station_ids that were not present in the station table. What percentage of these trips end up in end_station_ids which are also not present in the station table


Hopefully someone can help me, thank you.

What I have tried:

I have tried using date_diff function and group by gender but it seems error
Posted
Updated 6-Mar-21 4:34am

1 solution

See the SQL MAX and MIN functions: SQL MIN() and MAX() Functions[^]
Once you have got that working, you can start the rest of your homework ... but while we are more than willing to help those that are stuck: that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
   
Comments
Maciej Los 6-Mar-21 10:39am
   
5ed!
Lisa Sc 6-Mar-21 11:00am
   
Thank's for the insight!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900