Question: revenue of the orders placed from 2026-04-01 00:00:00 to 2026-05-01 00:00:00. A model returns the query below; its value is higher than your checked reference. What is the cause? SELECT SUM(o.quantity_product * p.price) AS revenue_cents
FROM orders o JOIN product p ON p.product_id = o.product_id
WHERE o.date BETWEEN '2026-04-01 00:00:00' AND '2026-05-01 00:00:00'

Question

Answer

The query adds up the unit prices without multiplying them by the quantities ordered.

Answer

The query returns NULL instead of 0 when no order falls within the period.

Answer

BETWEEN excludes the start bound: orders placed at exactly 2026-04-01 00:00:00 are left out of the sum.

Answer

BETWEEN includes the end bound: orders placed at exactly 2026-05-01 00:00:00 are counted, while the period is open on the right.

Crowdly

Question: revenue of the orders placed from 2026-04-01 00:00:00 to 2026-05-01 00...

Want instant access to all verified answers on learning.devinci.fr?