window-function-3.sql

SELECT
  *,
  count(*)
  OVER report_by_category         AS count,
  count(*)
  OVER ordered_report_by_category AS ordered_count
FROM
  employe
WINDOW
    report_by_category AS (
    PARTITION BY
      category
  ),
    ordered_report_by_category AS (
    PARTITION BY
      category
    ORDER BY
      salary
    RANGE
    BETWEEN UNBOUNDED PRECEDING
    AND UNBOUNDED FOLLOWING
  )
LIMIT 5;