Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribedimage text in transcribed

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.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administration The Complete Guide To Dba Practices And Procedures

Authors: Craig S. Mullins

2nd Edition

0321822943, 978-0321822949

More Books

Students also viewed these Databases questions

Question

=+nk so that p( B(k)) Answered: 1 week ago

Answered: 1 week ago