can please someone help me answer this following question in database 15. For ev

Question

can please someone help me answer this following question in database

15. For every condo, list the location number, unit number, owner number, owner’s first name, and owner’s last name.

16. For every service request for painting, list the condo ID, description, and status. 17. For every service request for electrical systems, list the condo ID, location number, unit number, estimated
hours, spent hours, owner number, and owner’s last name.
18. Create a new table named LargeCondo using all columns in the CondoUnit table for condos with square foot-
age greater than 1,500 square feet.

19. Use an update query to change the condo fee of any unit in the LargeCondo table whose fee is currently $300 to $550.

20. Use a delete query to delete all rows in the LargeCondo table in which the condo fee is $670.

21. How would you modify the query in Exercise 7 to list all condos with three bedrooms that are located in location number 1 or any condo in either location that is larger than 1,200 square feet?

Explanation / Answer

15.

Select location_num, unit_num,o. ownernum, o. firstname, o. lastname from cando_unit c, owner o where c. ownernum =o.ownernum;

16.

Select condoid, s.category_description as description ,status from service_category s, service_request r where s. category_num=r. category_num and s. category_description='painting';

17.

Select s. condoid, location_num, c. unit_num, s. est_hours, s. spent_hours, c. ownernum, o. lastname from condo_unit c, service_request s, owner o where s. Category_description ='electricalsystems' and s. condo_id=c. condo_id and c. ownernum =o. ownernum;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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