Skip to content

Instantly share code, notes, and snippets.

@niisar

niisar/Ch6_4.sql

Created May 20, 2014 16:00
Show Gist options
  • Save niisar/90f19ad92000584946e7 to your computer and use it in GitHub Desktop.
Save niisar/90f19ad92000584946e7 to your computer and use it in GitHub Desktop.
Download ZIP
refer to with clause
Raw
Ch6_4.sql
WITH AVG_WT_GENDER AS
(SELECT GENDER,AVG(WEIGHT) AS AVG_WT_SEX FROM CHILDSTAT GROUP BY GENDER
),
AVG_WT_OVERALL AS
(SELECT AVG(AVG_WT_SEX) AS AVG_WT_ALL FROM AVG_WT_GENDER
)
SELECT a.*
FROM CHILDSTAT a
WHERE a.WEIGHT >=
(SELECT AVG_WT_ALL FROM AVG_WT_OVERALL
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment