Databases Reporting with SQL Date and Time Functions Today's Report

What is wrong with this SQL query ? SELECT COUNT(*) FROM orders WHERE status = "shipped" AND ordered_on = DATE("now");

This is an attempt to answer one of the challenge questions. The question goes like this, Count the total number of orders with the status 'shipped' and were ordered today. Alias it to shipped_today.

The error that pops up says that the calculation is incorrect.

1 Answer