1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
---
source: prql-compiler/src/lib.rs
expression: sql
---
WITH table_1 AS (
SELECT
title,
country,
salary + payroll_tax + benefits_cost AS gross_cost,
salary + payroll_tax AS gross_salary,
salary
FROM
employees
WHERE
country = 'USA'
)
SELECT
title,
country,
AVG(salary),
SUM(salary),
AVG(gross_salary),
SUM(gross_salary),
AVG(gross_cost),
SUM(gross_cost) AS sum_gross_cost,
COUNT(*) AS ct
FROM
table_1
WHERE
gross_cost > 0
GROUP BY
title,
country
HAVING
COUNT(*) > 200
ORDER BY
sum_gross_cost
LIMIT
20