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 |