Question: can please someone help me answer this following question in database 15. For every condo, list the location number, unit number, owner number, owners first

can please someone help me answer this following question in database

15. For every condo, list the location number, unit number, owner number, owners first name, and owners 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 owners 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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!