I haven’t fully grasped the output in these codes - Why is there a “NULL”(no value) first row followed by “22” under count_baked_goods?
Heres the code in case this is in anyway different to the answer:
SELECT DATE(delivery_time), count(*) as count_baked_goods
GROUP BY DATE(delivery_time);
Because there are 22 goods whose delivery_time are NULL in the TABLE baked_goods,
you could see that by using
SELECT * FROM baked_goods WHERE delivery_time IS NULL;
Thank you!! Asked and answered.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.