Need help with sql.

Write the SQL commands for the following queries and show the output tables. List the property numbers and city of all properties that have been viewed. You need to eliminate duplicates from the list. Also, arrange the list by ascending order of city (alphabetic order), and within city, in descending order of property number (alphabetic order). 13 Pointsl 1. a. SQL Command: b. Output Table: 2. Assume, the salary column in staff table presents the annual salary of a staff. Now, list all staf with monthly salary less than 1000. In your list, show staff number, last name, and monthly salary. [2 Points] a. SQL Command: b. Output Table: 3. Find all clients with the string flintyrock' in their email address. In your list, show client number, last name, and email address. [1 Point] a. SQL Command: b. Output Table: Find the total number of female staff in the Staff table. You need to name the output column as NumOffemalestaff. [1 Point] 4. a. SQL Command: b. Output Table: 5. For each branch, find the number of staff working in each branch and the average of their salaries. Your output table should have three.columns: BranchNumbet, MvCount, MyAverase [2 Points] a. SQL Command: b. Output Table: Increase the number of rooms by 1 and rent by 10% of property PL94. Show your updated row. [1 Point] 6 a. SQL Command: b. Output Table