Almeda_A2_queries

txt

School

Montgomery College *

*We aren’t endorsed by this school

Course

123

Subject

Geography

Date

Oct 30, 2023

Type

txt

Pages

1

Uploaded by ElderTreeEmu9

Report
-- Question 1 SELECT geo_name AS "County", state_us_abbreviation AS "State", area_land AS "Area", population_count_100_percent AS "Population", CAST((population_count_100_percent / (area_land / 1000000.0)) AS numeric(12, 3)) AS "Pop. density (people/sq. km)" FROM us_counties_2010 WHERE state_us_abbreviation IN ('MD', 'PA') ORDER BY state_us_abbreviation ASC, "Pop. density (people/sq. km)" DESC; -- Question 2 -- Answer 1 COPY ( SELECT geo_name, state_us_abbreviation, internal_point_lat, internal_point_lon, CAST(population_count_100_percent AS numeric(12,2)) AS population, CAST(housing_unit_count_100_percent as numeric(12,2)) AS household, FROM us_counties_2010 WHERE state_us_abbreviation IN ('CA','TX','AK') ) TO '/Users/andreaalmeda/UMD/FALL 2023/INST 123/large_states.csv' WITH (FORMAT CSV, HEADER); -- Question 2 -- Answer 2 CREATE TABLE large_states ( county varchar(90), state varchar(2), latitude numeric(10,7), longitude numeric(10,7), population numeric(12,2), household numeric(12,2) ); -- Question 2 -- Answer 3 COPY large_states FROM '/Users/andreaalmeda/UMD/FALL 2023/INST 123/large_states.csv' WITH (FORMAT CSV, HEADER);
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Browse Popular Homework Q&A

Q: Maria needed 5 gallons of gas to fill her car's gas tank. The mileage odometer read 38,900 miles.…
Q: Assume a tax rate of 6.2% on $142,800 for Social Security and 1.45% for Medicare. No one will reach…
Q: Two passenger planes leave the same airport at the same time. The first travels at a heading of 85°…
Q: Banks are finding more ways to charge fees, such as a $25.40 overdraft fee. Sue McVickers has an…
Q: At the end of​ 2009, right after the great recession of​ 2008-2009, business partners Mario and…
Q: 2 (a) [²9 (b) (c) g(x) dx 9. J g(x) dx 7 [²9(x) g(x) dx
Q: Find the equation of the tangent line to the curve (a lemniscate) 2(x^2+y^2)^2=25(x^2−y^2) at the…
Q: Methylparaben is an ester used as a preservative in foods, beverages, and cosmetics. It is…
Q: what are the three types of conduit that can be bent with a hand bender? list code article…
Q: A truck weighing 1,379 N moving uniformly along a horizontal path experiences a friction force of…
Q: - A rifle with a weight of 30.0 N fires a 5.00-g bullet with a speed of 3.00 × 10² m/s. (a) Find the…
Q: The function P(x) = 4x? + 1625x – 4500 gives the profit when x units of a certain product are sold.…
Q: Nitrogen dioxide and water react to form nitric acid and nitrogen monoxide, like this: 3 NO₂(g) +…
Q: 16. It has been suggested that rotating cylinders about 10 mi long and 5.0 mi in diameter be placed…
Q: the first two are inncorrect
Q: 8 If f.° F. '8 +6³ ² f(x) dx = 31 and g(x) dx = 18, find 8 6.² [3f(x) + 5g(x)] dx.
Q: A researcher wants to provide a rabbit exactly 132 units of​ protein, 162 units of​ carbohydrates,…
Q: Determine all the reactions of the given structure. The surface against which the support D is…
Q: Which of the following proxies can be used to study temperatures on Earth for approximately the past…
Q: Janice has worked for Grandma B's Candies in the marketing department for 17 years. Last week, the…
Q: do you need to know an air parcel’s temperature or its specific humidity to determine its dew point…
Q: Plot the points ​(3​,−8​) and ​(8​,−8​) and draw a line through the points. What is the equation of…