Solmaris Condominium Group Case database is consist of the following tables.

Simply write the SQL command to obtain the desired results. No MS Access application is required. (7 pts for each)

List the unit number for every condo that has condo fee less than $650 for three bedrooms. (Simple Query)

List the location number and unit number for each condo whose condo fees are between $300 and $400 per month. (Simple Query)

List the location number, unit number, square footage, and condo fee for all units. Sort the results by condo fee within the square footage. (Simple Query)

List all the owners whose last name begins with A. (Use special operator)

List how many condo units in each location number. (Use Group By)

For every condo, list the location number, unit number, owner number, owners first name, and owners last name. (Use Joining tables)

For every service request for painting, list the condo ID, description, and status. (Use Joining tables)

For every service request for painting, list the condo ID, description, and status. (Use Subquery)

List the maximum condo fee. (Use Built-in Function)

(Bonus) List how many condo units that have max condo fee (Use Built-in Function and Subquery)

Location State PostalCode FL 31313 LocationNum LocationName Address City 1 Solmaris Ocean 100 Ocean Ave. Bowton 2 Solmaris Bayside 405 Bayside Blvd. Glander Bay FL 31044