Write a query that list all the tuples where the rent > 500. SORT by ascending rent values from PopertiesForRent

Write a query where fName has a J in it, in Staff relation

Write a query where comment Is Not Null in Viewing.

Write a query for PropertiesForRemnt that use a two keys type and rent, with the second key, rent, being descending.

Write a query that counts the number of clients in Client as noClients from Client relation

Write a query that Sums, averages, and finds min and max rent from PropertiesForRent

Write a query that counts the number of properties for rent as noPropForRent, averages the rent value and groups by branchNo from PropertyForRent