Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions