Namazbek Bekarysuly882 Points
What is wrong?
SELECT COUNT(product_id) AS shipped_today FROM orders WHERE status = "shipped" AND ordered_on = DATE(now);
Eric Butler33,475 Points
2 hints, because your first one is very close: You want to count all records (so count "id"s, which are always distinct); and the date function, if given no parameters, defaults to today, so you don't actually need any parameter in there. Good luck!