v

SQL Questions: 1. Write an SQL statement to list the staff full name and position of all staff who manage a property (propertyForRent). Sort the output according to postcode of the property in descending order (screenshot required). 2. List the highest salaried staff and show their first name and their position: give the column heading: 'Highest_Salary'. 3. Use an SQL statement to show how many properties does each owner own? 4. Show all the properties that are listed in each branch and the name of their owner: list the branch name, owner name along with the Property number and city. 5. Write an SQL statement to list all the properties with the type 'Flat'. 6. Write an SQL statement to list all the properties that have been viewed by clients less than 3 times and with comments containing something about rooms. More precisely, list the client full name, the client email, the propertyNo, the street of the property, and comments made for the viewings for that property. Order the output first by the client fName, then by the propertyNo (screenshot required). 7. Show the date of viewing and the number of times that each property for rent has been viewed and display the heading "Times Viewed for the resultant column. Sort by highest times viewed and most recent viewing 8. For the client 'Edward', 'Scissorhands', use SQL command to change this name to your own student name