Question 1:Write a query that returns the street number and street name as two d

Question

Question 1:Write a query that returns the street number and street name as two different columns then modify this query to list the different street names and the number of customers that live in each of those streets order by the number of customers descending

ESELECT TOP (1000) [customerID] ,[firstName] [lastName] [mainPhoneNo] [secondaryPhoneNo] , [email] , [addressLine1] , [addressLine2] [isp] FROM [CustomerDB]. [dbo] [Customers] Resuts Messages customerlD firstName lastName ainPhoneNo secondaryPhoneNo email addressLinel address Line2 Woodville South, SA 5011 WINDSOR GARDENS, SA 5087 SPRINGTON, SA 5235 Huntfield Heights, SA 5163 WINDSOR GARDENS, SA 5087 Campbeltown, SA Salisbury. 5109 Semaphore Park, SA 5019 Flinders Park, SA 5025 Hackham West Parks Jennifer Stone 0485 322 043 0403 988 232 8191 9399 kai@bigpond.com.au 72 Park Lake Boulevard NULL gvforeva@primus.net NULL NULL bshelza@adam.net.au 82 Fairfield Road NULL NULL NULL burksy@bigpond.com.au 15 Crescent Drive NULL Geoffrey Valenzuela 0405 824 981 NULL NULL NULL 1180 Grand Junction Road 40 Moules Road 11 Avocet Drive 39A Jetty Street NULL TPG NULL NULL NULL Adara Lionel Burton Vaughan Tilman Ferdinand Stark Tyrone Brady 0408 311 104 8359 4250 8348 1985 8335 8988 NULL 8335 9389 0408 822 492 Shelton 0400 949 005 NULL NULL NULL NULL 7 Richardson Place 40 Eizabeth Street 136 Folland Avenue NULL NULL NULL NULL 10 Burks

Explanation / Answer

select streetname,count(custometsID) as count from question1a

group by streetname

order by count(customerID) desc;

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.