This is for MY SQL
Write a query which defines a bike ride to be in the ‘Morning’ if the hour of its starttime is less than or equal to ‘12’, and in the ‘Afternoon’ otherwise. The query should count the total number of bike rides of each user type in the morning and in the afternoon thus defined (Hint - Using the citibikerides table, your output table should have three columns: usertype, TimeOfDay, and freq).
I am not sure what I am doing wrong. My query is listed below.
SELECT usertype,
(CASE WHEN strftime(starttime, '%H') <= 12 THEN 1 ELSE 0 END) AS morning_rides,
(CASE WHEN strftime(starttime, '%H') > 12 THEN 1 ELSE 0 END) AS afternoon_rides
FROM citibikerides
