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 trips; trips; etc...
Answer: SQL:
h How many trips are missing the value for the column year?
Answer:
SQL:
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
