|
Go to https://sqlframes.com/demo and in the code editor enter the following and execute (this example is taken from the first example on PRQL github page). It generates SQL, but it also computes and displays the results within the browser (though the data set below gives no results). const employees = SQL.values([{ title: 'Developer', country: 'USA', salary: 120, payroll_tax: 20, healthcare_cost: 6 }]);
employees.schemaName = 'employees';
const { groupBy, where: { gt, eq, and }, agg: { count, sum, avg } } = SQL;
return employees.pdf(SQL.script('[salary]+[payroll_tax]').as('gross_salary'),SQL.script('[gross_salary]+[healthcare_cost]').as('gross_cost'))
.fdf(and(gt('gross_cost',0),eq('country','USA')))
.gdf(groupBy('title','country')
,avg('salary').as('average_salary')
,sum('salary').as('sum_salary')
,avg('gross_salary').as('average_gross_salary')
,sum('gross_salary').as('sum_gross_salary')
,avg('gross_cost').as('average_gross_cost')
,sum('gross_cost').as('sum_gross_cost')
,count().as('count'))
.having(gt('count',200))
.orderBy('sum_gross_cost'); |