1.Add 2 new records in the 'CLIENT' table: a record about you and another about your group member, where clientNo = your student ID, fName = your first name and lName = your last name. (screenshot required to show the newly inserted records). If this question is not done, then only 50% can be awarded for the remaining questions considering they are correct.

2.SQL statement to list the branch city, and the staff full name in one column, as well as the DOB of all staff who DO NOT work in the 'London' branch. Sort the output according to postcode in descending order (screenshot required).

3.SQL statement to list all the properties that have been viewed by one or more clients more than 2 times. More precisely, list the client full name, the client email, the propertyNo, the street of the property, and all the viewings that occurred for that property. Order the output first by the client fName, then by the propertyNo (screenshot required).

Show the number of times that each property for rent has been viewed and display the heading "Times_Viewed' for the newly calculated column.

List the highest salaried staff and show their first name and their position: give the column heading: 'Highest_Salary'.