月次新規購入者の抽出

Question

経営企画は10月の新規購入者数を速報で把握したいと考えています。`orders` から 2025年10月中に `status = 'paid'` となった注文を注文日が古い順で取得するSQLを選んでください。

Accepted Answer

SELECT order_id, customer_id, order_date FROM orders WHERE status = 'paid' AND order_date BETWEEN DATE '2025-10-01' AND DATE '2025-10-31' ORDER BY order_date;

Answer

SELECT order_id, customer_id, order_date FROM orders WHERE status = 'paid' AND order_date BETWEEN DATE '2025-10-01' AND DATE '2025-10-31' ORDER BY order_date DESC;

Answer

SELECT order_id, customer_id, order_date FROM orders WHERE status IN ('paid', 'pending') AND order_date BETWEEN DATE '2025-10-01' AND DATE '2025-10-31' ORDER BY order_date;

Answer

SELECT order_id, customer_id, order_date FROM orders WHERE status = 'paid' AND order_date >= DATE '2025-10-01' ORDER BY order_date;

SQL基礎：顧客セグメント分析