Using SQL Server Management Studio (SSMS) 2016 or 2017: 1. Create a view named v

Question

Using SQL Server Management Studio (SSMS) 2016 or 2017:

1. Create a view named vw_Fees which list the owner number, owner’s first and last name, location      

      number, unit number, square footage and condo fee for each unit ordered by owner last name,

      owner first name, unit number.

2. Create a view named vw_TotalFee which calculates the total fees that can be collected.

3. Create a view named vw_LaborCost which list condo ID, category number, estimated hours and

      estimated labor cost.   Estimated labor cost is calculated at an hourly rate of $35 per hour.

Explanation / Answer

CREATE VIEW vw_Fees AS
SELECT owner_number, firstName, lastName, location_number, unit_number, square_footage, condo_fee FROM Owners ORDER BY lastName, firstName, unit_number;

CREATE VIEW vw_TotalFee AS
SELECT SUM(fee) FROM Records;

CREATE VIEW vw_LaborCost AS
SELECT condo_ID, category_number, estimated_hours, (35 * labor_cost) FROM laborRecords;

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

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