home / 2021_tech_salaries / saved_queries

Menu
  • PublicMatt

saved_queries: category_averages

This data as json

name sql author_id
category_averages select job_category ,avg(salary) as salary ,count(1) as count from salaries where CURRENCY = 'USD' group by job_category having count(*) > 5 order by avg(salary) desc  
Powered by Datasette · Queries took 1.758ms