Question: need help with what SQL commands to use to get the following answers regarding the table TRIPS. e . How many trips were made in

need help with what SQL commands to use to get the following answers regarding the table TRIPS.
e. How many trips were made in January?
Answer: ______
SQL: ____________________________________________________
f. Find the minimum and maximum (not empty) years of all trips.
Answer: ____________
SQL: ____________________________________________________
g. Find the number of trips for each year included in the dataset. (Hint: it looks like 2009(123 trips); 2010(123 trips); etc...)
Answer: __________________________________________________ SQL: ____________________________________________________
h. How many trips are missing the value for the column year?
Answer: _________
SQL: ____________________________________________________
need help with what SQL commands to use to get

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!