Answered step by step
Verified Expert Solution
Question
1 Approved Answer
based off the physical design above, answer the following questions in SQL How many customers live in Texas? How much does Extra Service X(gift card)
based off the physical design above, answer the following questions in SQL
How many customers live in Texas?
How much does Extra Service X(gift card) cost?
How many customers have TV package A?
What state uses the most extra services?
How many Bills are associated with each customer?
How many states do Comcast customers live in?
Which state has the most bills?
How many TV packages are available through Single Service Pricing?
How many Internet packages are available through Single Service Pricing?
How many cities do Comcast customers live in?
Single Service Pricing Bundle Bund eID INT Property City VARCHAR(15 Phone Phone!D VARCHAR(5) TVMD VARCHARE) Duration INT Property ZIP VARCHARIS Bunde A BundielD INT Bunde -Bundlel0 NT Bundle A Bundle Phone First Name VARCHAR20) Last Name VARCHAR(45) Address VARCHAR(45) City VARCHAR15) State VARCHAR 2 ZIP VARCHARS Phone VARHARi1 TV TVID INT Channels INT Free-HD DECIMAL(1) Prico DECIMAL/10.2) InternetID INT Price DECIMAL 10,2 1024) | | Bill Bling Dae DATETIME Due Dae DATET ME Amout DECIMAL 10,2) BI Start Date DATETME End Cate CATETIME Bundle BundlelD INT NT Contract ContractlD1 BIl Contrsct ContraMID INT ? Single Service Pricing-SnglaserviDelD VARCHAR(18 Extra TypelD Extra Services TypelD VARCHAR11Step 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