Instructions
Read the following and write the SQL that would provide the data to answer the question. Turn in the SQL. You do not need to turn in the results of the query.
1.List all the persons with their addresses. (Use inner join Syntax)
3. List all the the persons with their addresses (use equi-join syntax)
4. List all the persons with their home phone numbers.
5. List the first name, last name, and hire date of all employees
5. List all the first name and last name and email address of all persons with email addresses (Exclude those without)
6. List the lastname, the address and all the contacts of the person with the lastname of "Tanner"(use inner join syntax)
7. Rewrite 6 with equijoin syntax
8.List all the grants with the service type "rent". List the service type by name and also list the employee's last name that was involved in the grant.
9. Which service type(s) have never been granted. (outer join)
10. Which Contact type(s) were never used.