please answer 6 and 7

Page view Robo - + wws WUNO ums Son JU low: Branch g brancho street aty postcode Staff staffio Name Name Client g diento flame Name tello prefType maxRent position sex DOB salary brancho Mal Property For Rent g property to street aty postcode type rooms rent Owner No staffo brancho Viewing g diento g property viewDate comment Private Owner ownerlo frame Name ADDress telo 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 property No, 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