How many customers live in Texas? How much does Extra Service X(gift card) cost?

Question

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 VARCHARÇ15) 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 VARCHAR11

Explanation / Answer

Solution:

Note: The first four subparts have been answered as per Chegg guidelines, please repost others

How many customers live in Texas?

SELECT DISTINCT COUNT(CustomerID) FROM Customer WHERE State= 'Texas'

How much does Extra Service X(gift card) cost?

SELECT fee FROM Extra Service WHERE typeID = 'X'

How many customers have TV package A?

SELECT DISTINCT COUNT(CustomerID) FROM Customer, Property, Bill, Contract, Internet, TV WHERE Bundle_BudleID= 'A'

What state uses the most extra services?

SELECT State FROM Customer, Property, Bill, Bill_Service_line, Extra Services WHERE COUNT(CustomerID)> COUNT (CustomerID) GROUP BY State

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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