DATES II - 3/9 - Why is the first row showing blank and "22" respectively?

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
FROM 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

FROM baked_goods
WHERE delivery_time IS NULL;

Happy learning!

Thank you!! Asked and answered.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.