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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started