Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a query to return the number of unique electric vehicles ( identified by unique VIN ) per census tract in Washington state along with
Write a query to return the number of unique electric vehicles identified
by unique VIN per census tract in Washington state along with the median
household income of that census tract in for only tracts where the
median household income is available. The query should return only the top
tracts ordered by highest median income. The output table should have three
columns: censustract, numcars number of unique cars in that tract and me
dianhhincomeevwa
Columns
id
vin
county
city
state
postalcode
modelyear
make
model
evtype
cafveligibilit.
electricrange
basemsrp
censustractColumns
id
gisjoin
year
stateabbrev
regioncode
divisioncode
statename
statecode
countyname
countycode
countysubdivcode
placecode
tractcode
citycode
censusgeoid
tribalcensustractcode
areanamee
medianhhincome
medianhhincome
medianhhincome
medianhhincome
medianhhincome
medianhhincome
medianhhincome
medianhhincome
medianhhincomeerror
medianhhincomeerror
medianhhincomeerror
medianhhincomeerror
medianhhincomeerror
medianhhincomeerror
medianhhincomeerror
medianhhincomeerror
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started