Using Solmaris table which I don\'t have a good quality of :( List the list the

Question

Using Solmaris table which I don't have a good quality of :( List the list the location number, unit number and condo fee for condos whose owners live in Bowton or own a one-bedroom condos List the location number, unit number, and condo fee for condos whose owners live in Bowton and own a one bedroom condo List the location number unit number and condo fee for condos whose owners live in Bowton but do not own one bedroom condos List the condo ID, square footage, owner number, service ID, number of estimated hours and number of spent hours for each service request List the condo ID, square footage, owner number, service ID, number of estimated hours and number of spent hours for each service request on which the category number is 4

Explanation / Answer

6. SELECT LocationNum, UnitNum, CondoFee from CondoUnit, Owner where Owner.OwnerNum=CondoUnit.OwnerNum and (Owner.City = 'Bowton' or Bdrms=1)

7 is same as 6

8. SELECT LocationNum, UnitNum, CondoFee from CondoUnit, Owner where Owner.OwnerNum=CondoUnit.OwnerNum and Owner.City = 'Bowton' and Bdrms<>1

9. Select CondoID, SqrFt, OwnerNum from Condounit

For complete solution of 9 and 10 you should share complete question. without table details answer cannot be shared.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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