saved_queries
1 row
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
CREATE TABLE [saved_queries] ( [name] TEXT PRIMARY KEY, [sql] TEXT, [author_id] TEXT );