Skip to content

Instantly share code, notes, and snippets.

@avivl

avivl/Self selection bias.sql

Last active December 25, 2017 13:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save avivl/e9ecfdb9342a23af9a6515b40d581e4e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save avivl/e9ecfdb9342a23af9a6515b40d581e4e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Self selection bias.sql
SELECT quality ,ratio * 100 AS percent,total FROM (
SELECT quality , count(*) AS total, RATIO_TO_REPORT(total) OVER() AS ratio
FROM [telegrass_reviews.reviews]
GROUP by quality
)
SELECT price ,ratio * 100 AS percent,total FROM (
SELECT price , count(*) AS total, RATIO_TO_REPORT(total) OVER() AS ratio
FROM [telegrass_reviews.reviews]
GROUP by price
)
SELECT quality ,ratio * 100 AS percent,total FROM (
SELECT quality , count(*) AS total, RATIO_TO_REPORT(total) OVER() AS ratio
FROM [telegrass_reviews.reviews]
GROUP by quality
)
SELECT communication ,ratio * 100 AS percent,total FROM (
SELECT communication , count(*) AS total, RATIO_TO_REPORT(total) OVER() AS ratio
FROM [telegrass_reviews.reviews]
GROUP by communication
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment