Question is

1.Give the SQL command to display the address, monthly rent, and yearly rent for properties with 3 bedrooms. Yearly rent is computed as the monthly rent times 12.

My code that I have come up with is

SELECT ADDRESS ,MONTHLY_RENT, YEARLY RENT, MONTHLY_RENT FROM PROPERTY WHERE = ;

I can never figure out the "where " statement

2.. Give the SQL command to display the SURNAME and FIRST_NAME of RESIDENTS. The list should be sorted by FIRST_NAME within SURNAME. (SURNAME is the major key. FIRST_NAME is the minor key.) The list provided is truncated to save space. You will have more records outputted.

I