[Solved] Using Microsoft Access Friendly Sql Please Write Sql Code Determine Following Questions 1 Q37225477

Using Microsoft Access Friendly SQL, please write SQLcode to determine the following questions:

1] Find out the number of properties that are managed by thestaffs whose working branch is located in London.

2) Which property is viewed by clients the most?

3) Find out the names of the clients who have viewed a house andleave a comment.

4) Find out the clients who are registered to branches that arelocated in Glasgow.

5) Please display the first and last name of the client whoviewed the most expensive property. (Use MySQL)

Table Relationships:

Registration 0oclientNo Client clientNo fName IName telNo Branch branchNo street 0O branchNo staffNo dateJoined postcode Viewing clientNo property viewDat Staff staffNo fName IName position sex DOB salary branchNO PropertyForRe.. PrivateOwner propertyNo street ownerNo fName IName address telNo postcode rooms rent ownerNo staffNo branchNo 0O Show transcribed image text Registration 0oclientNo Client clientNo fName IName telNo Branch branchNo street 0O branchNo staffNo dateJoined postcode Viewing clientNo property viewDat Staff staffNo fName IName position sex DOB salary branchNO PropertyForRe.. PrivateOwner propertyNo street ownerNo fName IName address telNo postcode rooms rent ownerNo staffNo branchNo 0O

Expert Answer

---

Answer to Using Microsoft Access Friendly SQL, please write SQL code to determine the following questions: 1] Find out the number … . . .