Organise Your SQL - Query Stash

QueryStash

Organise your
SQL snippets!

For analysts, engineers or data scientists, Query Stash makes organising and finding your SQL code and snippets easier.

Try out our Free account

Save time and optimise your workflow!

Save SQL snippets

An easy way to store useful SQL snippets or entire queries, in a taggable and searchable stash. Making it easier to find the query you need quickly.

Organise into collections

Break your stash up into organised collections. Create groups of queries around your own specific projects or realted snippets its up to you.

Share your queries

Sharing tips, learnings or useful queries with the world or just your team, you can pick and choose what to share and with whom

Discover popular snippets

Browse the public stash from all users for interesting querys and view the most popular right now.

An actual SQL snippet example...

Outlier Detection using Z-Scores

1SELECT 
2  *
3FROM (
4  SELECT
5    *    
6    , (avg_duration - AVG(avg_duration) OVER ()) / STDDEV(avg_duration) OVER () AS z_score
7  FROM (
8    SELECT 
9      bike_id
10      , AVG(duration) AS avg_duration
11    FROM `bigquery-public-data.london_bicycles.cycle_hire` 
12    GROUP BY
13      bike_id
14  )
15)
16WHERE z_score >= 3
17ORDER BY z_score DESC

SELECT 
  *
FROM (
  SELECT
    *    
    , (avg_duration - AVG(avg_duration) OVER ()) / STDDEV(avg_duration) OVER () AS z_score
  FROM (
    SELECT 
      bike_id
      , AVG(duration) AS avg_duration
    FROM `bigquery-public-data.london_bicycles.cycle_hire` 
    GROUP BY
      bike_id
  )
)
WHERE z_score >= 3
ORDER BY z_score DESC

Public

stats outliers

QueryStash

Created: Sep 29th 2020

View this actual public query to see the full detailed version here.