SQL文（クエリ）

SELECT
  COUNT(*) AS orders_over_avg_rev
FROM
  sample.sales
WHERE
  revenue > (
    SELECT
      AVG(revenue) AS avg_rev
    FROM
      sample.sales
    WHERE
      is_proper IS TRUE
  )
AND is_proper IS TRUE

結果テーブル

サポートページに戻る