Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 BurksStep 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