home / 2021_tech_salaries

Menu
  • PublicMatt

saved_queries

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

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  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [saved_queries] (
   [name] TEXT PRIMARY KEY,
   [sql] TEXT,
   [author_id] TEXT
);
Powered by Datasette · Queries took 2.307ms