Assignment title: Information
2. SQL query As a way to demonstrate success, you are to implement a series of queries on the database to reflect the business logic of The Best Home. Note: You are to create the queries manually by using the SQL view of MS Access query builder to demonstrate your competency in SQL. Failing to do so may result in marks to be deducted. Query-1: List all the contact details of a particular customer to show: • The customer's name • The contact type e.g. email • The contact details e.g. [email protected] Note: the customer's name is a parameter to enter when executing this query in Microsoft Access. A customer could have more than one contact e.g. email, mobile and home phone. Query-2: List all the rental properties that the asked prices (the price on the advertising) are the same as the rent prices (the price on the rent contract) to show: • The property type • The property address • The asked price