ANSWER THE FOLLOWING QUESTIONS IN SQL BASED OFF THE PHYSICAL DESIGN ABOVE, NO RELATIONAL SCHEMA IS NEEDED TO ANSWER THESE QUESTIONS, i dont have one either and its not needed.

Which TV packages have Free HD?

How many channels does TV package X have?

In what year did the most customers sign up for Comcast services?

Which state has the fewest properties?

Property Propenty Address VARCHAR25) Property Chy VARCHAR15 Propery State VARCHAR2) Single Service Pricing SinglaServiceD INT Phone PhonelD VARCHARI5) TV-TO VARCHAR(5) Bundle Bund eID INT Bunde Price INT Duration INT Bunde A BundlelD INT Bundle B BundlelD INT Indexes Bundle A Bundle B Phone TV BundeID INT Bundle DNT First Name VARCHAR 20 Last-Name VARCHAR(46) Address VARCHAR(45) ? ? VARCHAR(1 Stato VARCHAR2 ZIP VAHCHAH(5) Phone VARCHARI1 PhonelD INT P TVID INT IntemetID INT Price DECIMAL 10,2 Description VARCHAR(1024) ?package VARCHAR( 255) O Channels INT Cescription VARCHAR(1024) Free HD DECIMAL(T) Price DECIMALI Description VARCHARI1024) B IID I Payment ing Date DATETIME Due Date DATETIME Contract ContractiID INT Start Date DATETIME End Date DATETIME BL BIID INT Contract ContradtiD1 INT Bil Conract ContradID INT Singie Sarvice Prioing SngleServicelD VARCHAR 18 Extra pelD INT BII BID INT Extra Services TypelD VARCHAR11) Fee DEC MAL(10.2) Property Propenty Address VARCHAR25) Property Chy VARCHAR15 Propery State VARCHAR2) Single Service Pricing SinglaServiceD INT Phone PhonelD VARCHARI5) TV-TO VARCHAR(5) Bundle Bund eID INT Bunde Price INT Duration INT Bunde A BundlelD INT Bundle B BundlelD INT Indexes Bundle A Bundle B Phone TV BundeID INT Bundle DNT First Name VARCHAR 20 Last-Name VARCHAR(46) Address VARCHAR(45) ? ? VARCHAR(1 Stato VARCHAR2 ZIP VAHCHAH(5) Phone VARCHARI1 PhonelD INT P TVID INT IntemetID INT Price DECIMAL 10,2 Description VARCHAR(1024) ?package VARCHAR( 255) O Channels INT Cescription VARCHAR(1024) Free HD DECIMAL(T) Price DECIMALI Description VARCHARI1024) B IID I Payment ing Date DATETIME Due Date DATETIME Contract ContractiID INT Start Date DATETIME End Date DATETIME BL BIID INT Contract ContradtiD1 INT Bil Conract ContradID INT Singie Sarvice Prioing SngleServicelD VARCHAR 18 Extra pelD INT BII BID INT Extra Services TypelD VARCHAR11) Fee DEC MAL(10.2)