ii. Write an SQL statement to list the branch postcode, and the names of all
staff in the ‘London’ branch. Sort the output according to postcode
(screenshot required). (1 mark)
iii. Write an SQL statement to list all the properties that have been viewed by
one or more clients. More precisely, list the client full name, the client
email, the propertyNo, the street of the property, and all the viewings that
occurred in Jan-2018′ date. Order the output first by the client fName, then
by the propertyNo (screenshot required). (1.5 marks)
iv. Show the number of times that each property for rent has been viewed.
(1.5 marks)
v. List the highest salaried staff and show their first name and their position:
give the column heading: ‘Highest_Salary’. (1.5 marks)
vi. Use an Inner Join and show all the staff who work in the ‘London’ branch:
list the staff Number and the full name along with the branch city. (
ASSIGNMENT-TW….pdf
ass-2-requirm….docx
AS-2-example-….pngLocate a suitable environment for conducting a work health safety risk assessment. This may be your own workplace, the workplace of a friend or family member, or a home office space. Make sure that you seek permission to conduct an assessment in a professional environment?
August 10, 2020
6:45 pm
Read More »
