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 2 0 2 0 , for only tracts where the 2 0 2 0 median household income is available The query should return only the top 1 0 tracts ordered by highest median income The output table should have three columns census tract, num cars ( number of unique cars in that tract ) , and me dian hh income 2 0 2 0 ev wa Columns ( 1 4 ) id vin county city state postal code model year make model ev type cafv eligibilit electric range base msrp census tractColumns ( 3 3 ) id gisjoin year state abbrev region code division code state name state code county name county code county subdiv code place code tract code city code census geo id tribal census tract code area name e median hh income 2 0 2 0 median hh income 2 0 2 0 1 median hh income 2 0 2 0 2 median hh income 2 0 2 0 3 median hh income 2 0 2 0 4 median hh income 2 0 2 0 5 median hh income 2 0 2 0 6 median hh income 2 0 2 0 7 median hh income 2 0 2 0 error median hh income 2 0 2 0 error 1 median hh income 2 0 2 0 error 2 median hh income 2 0 2 0 error 3 median hh income 2 0 2 0 error 4 median hh income 2 0 2 0 error 5 median hh income 2 0 2 0 error 6 median hh income 2 0 2 0 error 7

Question

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 2 0 2 0 , for only tracts where the 2 0 2 0 median household income is available  The query should return only the top 1 0 tracts ordered by highest median income  The output table should have three columns  census   tract, num   cars ( number of unique cars in that tract ) , and me   dian   hh   income   2 0 2 0   ev   wa Columns ( 1 4 ) id vin county city state postal   code model   year make model ev   type cafv   eligibilit  electric   range base   msrp census   tractColumns ( 3 3 ) id gisjoin year state   abbrev region   code division   code state   name state   code county   name county   code county   subdiv   code place   code tract   code city   code census   geo   id tribal   census   tract   code area   name   e median   hh   income   2 0 2 0 median   hh   income   2 0 2 0   1 median   hh   income   2 0 2 0   2 median   hh   income   2 0 2 0   3 median   hh   income   2 0 2 0   4 median   hh   income   2 0 2 0   5 median   hh   income   2 0 2 0   6 median   hh   income   2 0 2 0   7 median   hh   income   2 0 2 0   error median   hh   income   2 0 2 0   error   1 median   hh   income   2 0 2 0   error   2 median   hh   income   2 0 2 0   error   3 median   hh   income   2 0 2 0   error   4 median   hh   income   2 0 2 0   error   5 median   hh   income   2 0 2 0   error   6 median   hh   income   2 0 2 0   error   7

Accepted Answer

The Answer is in the image, click to view ...

Question

Write a query to return the number of unique electric vehicles ( identified by unique VIN ) per census tract in Washington state along with

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Relational Theory For Computer Professionals What Relational Databases Are Really All About

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question