Question
Use SQL Server to complete this section. Create the database for Solmaris and then run the Solmaris script that can be found in Moodle. This
Use SQL Server to complete this section. Create the database for Solmaris and then run the Solmaris script that can be found in Moodle. This will create tables and records needed for this portion. Create the queries to find the following information: 3. List the owner number, last name, and first name of every condo owner who owns more than one condo. 4. List the last name and first name of every owner who does not live in Lewiston. 5. List the location number and unit number for every condo whose square footage is equal to or greater than 1,200 square feet. 6. List the unit number for every condo with two bedrooms that is located in location number 1. 7. Labor is billed at the rate of $45 per hour. List the condo ID, category number, estimated hours, and estimated labor cost for every service request. Use the column name ESTIMATED_COST for the estimated labor cost. 8. List the owner number and last name for all owners who live in Florida (FL), Georgia (GA), or South Carolina (SC). 9. How many three-bedroom condos are located at each location? 10. Calculate the total condo fees Solmaris receives each month.
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