Question

Query 1-1

Display realtor staff number, name, position, annual salary as Annual Salary and monthly salary as Monthly Salary. Round monthly salary to 2 decimal places. Sort output by staff number ascending.

Numb Staff Name                               Position             Annual Salary Monthly Salary

---- ---------------------------------------- -------------------- ------------- --------------

Query 1-2

For rental properties that have been rented for less than the listing rental rate (REN_RATE), display rental property number, street, city, state, zip, the listing rent rate and actual rental rate.

Prop Street                    City                 St Zip C Contract Rate Rent Rate

---- ------------------------- -------------------- -- ----- ------------- ----------

Query 1-3

For each listed rental property, display the rental property number, street, city, state, type, number of rooms, rent, owners first and last name, listing agents name and commission and listing branch name. Order by listing agent.

Prop Street                    City                 St Type                 Rooms       Rent Owner First Owner Last Name Listing Agent     Comm Percent Branch

---- ------------------------- -------------------- -- --------------- ---------- ---------- ------------ --------------- ----------------- ------------ ---------

Answer 1

Query 1-1: select Numb_staff, Name, Position, Annual_Salary as [Annual Salary], Round(Monthly_Salary, 2) as [Monthly Salary] from table_name order by numb_staff

Query 1-2: select * from table_name where Contract_Rate < Ren_Rate

Query 1-3: select * from table_name order by listing_agent

NOTE: Since the table name was not declared in the question, feel free to change the table_name as the actual name of the table
If there is anything you would like to know please leave a comment. Thank you.