Learn
Nice work! Now let’s assume that we have a column in our baked_goods
table named manufacture_time
in the format YYYY-MM-DD hh:mm:ss.
We’d like to know the number of baked_goods
manufactured by day, and not by second. We can use the DATE()
function to easily convert timestamps to dates and complete the following query:
SELECT DATE(manufacture_time), count(*) as count_baked_goods FROM baked_goods GROUP BY DATE(manufacture_time);
Similarly, we can query the time with
SELECT TIME(manufacture_time), count(*) as count_baked_goods FROM baked_goods GROUP BY TIME(manufacture_time);
Instructions
1.
Find the number of baked goods by date of delivery.
Be sure to alias the total count of baked goods as count_baked_goods
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.