Mike-Brassil-CS-102-SQL.docx - Mike Brassil - CS102 SQL...

Doc Preview
Pages 2
Identified Q&As 1
Total views 7
Mike Brassil – CS102 SQL CODE Exercise 14 @@ -190,7 +190,7 @@ FROM us_counties_2010_shp ORDER BY square_miles DESC LIMIT 5; -- Listing 14-16: Find the county belonging to a pair of -- Listing 14-16: Using ST_Within() to find the county b SELECT name10, statefp10 @@ -219,7 +219,7 @@ WHERE ST_Within('SRID=4269;POINT(-11 -- -- Here, H3010: A natural flowing waterway -- Listing 14-17: Use ST_GeometryType() to determine geo -- Listing 14-17: Using ST_GeometryType() to determine g SELECT ST_GeometryType(geom) FROM santafe_linearwater_2016 @@ -239,7 +239,7 @@ FROM santafe_linearwater_2016 water WHERE water.fullname = 'Santa Fe Riv' ORDER BY roads.fullname; -- Listing 14-19: Use ST_Intersection() to show where ro -- Listing 14-19: Using ST_Intersection() to show where SELECT water.fullname AS waterway,
Course Hero Badge

End of preview

Want to read all 2 pages? Upload your study docs or become a member.
Unformatted text preview:-- Listing 14-19: Using ST_Intersection() to show where SELECT water.fullname AS waterway, roads.rttyp, @@ -241,7 +241,7 @@ ORDER BY count(*) DESC; SELECT stabr, count(*) FROM pls_fy2014_pupld14a GROUP BY stabr ORDER BY count(stabr) DESC; ORDER BY count(*) DESC;-- Listing 8-10: GROUP BY with count() on the stabr and statad Note: CLONE With this script: git clone -n cd sql-server-samples git config core.sparsecheckout true echo samples/features/*| out-file -append -encoding ascii .git/info/sparse- checkout echo samples/demos/*| out-file -append -encoding ascii .git/info/sparse- checkout git checkout