Skip to content

Instantly share code, notes, and snippets.

@digital-old-school-journey

digital-old-school-journey/avg.sql

Last active January 23, 2019 08:20
Show Gist options
  • Save digital-old-school-journey/995442af2c8be02d06ad311d9da45650 to your computer and use it in GitHub Desktop.
Save digital-old-school-journey/995442af2c8be02d06ad311d9da45650 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
avg.sql
SELECT AVG(CASE WHEN num = 0 THEN NULL ELSE num END)
FROM(
SELECT 2.0 as num
UNION ALL
SELECT 0
UNION ALL
SELECT NULL
UNION ALL
SELECT 1
) AS t
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment