Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CAST (COUNT(DISTINCT our.unique_id) AS FLOAT) / (SELECT COUNT(*) FROM our_Schools) * 100
- FROM
- -- Our Schools
- (SELECT
- REPLACE(LOWER(st.abbr + sc.city + sc.district + sc.name), ' ', '') AS unique_id
- FROM
- dbo.our_Schools sc
- INNER JOIN States st
- ON sc.state = st.fips) our
- INNER HASH JOIN
- -- GS
- (SELECT DISTINCT
- REPLACE(LOWER(st.abbr + e.city + e.district_name + e.name), ' ', '') AS unique_id,
- e.universal_id
- FROM
- dbo.GS_Entities e
- INNER JOIN States st
- ON e.state_id = st.fips
- WHERE
- e.entity_id = 3 /* schools */) gs
- ON our.unique_id = gs.unique_id
- INNER JOIN dbo.GS_Census c
- ON gs.universal_id = c.universal_id
- AND c.data_type_id = 2 -- enrollment
- AND CAST(c.value AS INTEGER) < 600
Advertisement
Add Comment
Please, Sign In to add comment