割引適用明細の抜け漏れチェック

Question

プロモーション担当は、割引が正しく適用された明細を確認したいと考えています。`order_items` から `discount_rate > 0` の行を割引率が高い順に取得するSQLを選んでください。

Accepted Answer

SELECT order_id, product_id, quantity, discount_rate FROM order_items WHERE discount_rate > 0 ORDER BY discount_rate DESC;

Answer

SELECT order_id, product_id, quantity, discount_rate FROM order_items WHERE discount_rate >= 0 ORDER BY discount_rate DESC;

Answer

SELECT order_id, product_id, quantity, discount_rate FROM order_items WHERE discount_rate > 0 ORDER BY discount_rate;

Answer

SELECT order_id, product_id, quantity, discount_rate FROM order_items WHERE discount_rate >= 0.5 ORDER BY discount_rate DESC;

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