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


#1

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?


#2

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);


#3

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;


Happy learning!


#4

Thank you!! Asked and answered.


#5

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