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

1. Create a view named LargeCondo using the condo ID, location number, unit number, condo fee, and owner number for those condos with square footages of greater than 1,200 square feet.

2. Create a view named initialService using the condo ID, category number, description, and estimated hours for ever service request for which the spent hours are zero.

3. Create a view named NumberOfBedrooms using the Bdrms column and a count of all condos of each bedroom size.