Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Now we are trying to figure out if our customers are using our data plans efficiently. We have Unlimited plans that throttle the data at
Now we are trying to figure out if our customers are using our data plans efficiently. We have Unlimited plans that throttle the data at specific limits and then there are plans for caps on data usage. We want to know ultimately if there is a city that uses a lot of data (within the top 3 data using cities) but none of our customers in that city are using the Unlimited Plans. If there is a city like that, which one is it?
Use one query if possible
Database:
MIN 0586692155 1007772121 2568884578 3596687555 4491200222 5996582255 6806963511 7995551212 8546589922 9112526993 5511523489 5284865985 2345824215 6582455428 5322487122 1287548752 0258999542 0458524896 5698875875 7588753254 Last Month Usage Minutes DatalnMB Texts 21210950 7825352 1551 1221 359 1912 101 21052 855 10000 715 11256 311 25332 257 7259 125 52669 250 25003 125 21563 320 10256 112 12356 288 12568 702 10235 533 52339 352 36588 365) 12635 988 31022 1533 20159 12335 15332 7596 10121 9663 98254 12369 1752 63352 3252 8449) 12452 15236 22542 21332 4253 4256 22368 Ave. MIN 0586692155 1007772121 2568884578 3596687555 4491200222 5996582255 6806963511 7995551212 8546589922 19112526993 5511523489 5284865985 2345824215 6582455428 5322487122 1287548752 0258999542 0458524896 1500 Subscriber FirstName LastName StreetAddress City State Steve Rogers 123 America Blvd. Seattle WA Clint Barton 332 Quiver Road Spokane WA Charles Xavier 4566 Cerebral Ave. Seattle WA Carol Danvers (1332 Marvel Blvd. Tacoma WA Peter Parker 1002 1st Ave. Seattle WA Natasha Romanova 12 Secret Way Olympia WA Jessica Jones 145 Jewel Road Spokane WA Wade Wilson 4 Wall Blvd. Everett WA Tony Stark 1500 Stark Ave. Redmond WA Nathan Summers 1784 Times Blvd. lissaquah WA Eddie Brock 15 Venom Way Olympia WA Bruce Banner 123 Smash Road Everett WA Jane Foster 556 Thunder Ave. Seattle WA Bucky Barnes 881 Silver Way Bellevue WA Matt Murdock 9001 Justice Road Redmond WA Frank Castle 6616 Punish Ave. Seattle WA Ben Grimm 400 Clobberin Way Bellevue WA Reed Richards 136 Fantastic Blvd. Olympia WA Richards 136 Fantastic Blvd. Olympia WA Johnny Storm 6472 Flames Road Kent WA Zip Code MDN 98121 206-956-8855 99223 509-224-5655 98107206-552-7899 98403/253-996-1125 98121 206-365-5421 98504 360-855-1112 99201 509-699-8447 98206 425-445-9696 98052 425-669-8221 980721425-777-3322 98501 360-522-6593 98201 425-663-4528 98109 206-544-7885 98015 425-663-9985 98053 425-888-2235 98121 206-112-5886 98007 425-365-5224 198502 360-533-2237 98502 360-248-5582 98030253-689-5513 PlanName UnlBasic Data50 UnlSuper Data2 Data 25 Data 10 UnlBasic UnlPrime UnlPrime UnlPrime Data50 Data50 Data25 Data 10 UnlBasic UnlPrime Data50 UnlBasic UnlBasic UnlSuper 7588753254 PlanName UnlPrime UnlSuper UnlBasic Data50 Data25 Data 10 Data2 MPlan Minutes Data Throttle Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited 50 NULL Unlimited 25 NULL Unlimited 10 NULL Unlimited 2 NULL Cost 50 150.00 25 125.00 101 100.00 85.00 65.00 50.00 40.00Step 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