More practice with Joins $\backslash$& Set Operators

$1.$ Equality Join: Write a query that will retrieve the names of customers along with the titles of the books they have ordered. To do this, you will need to join customer, orders, and orderitems tables with the books table on their common fields. $($Pks $\backslash$& Fks$)$

$2.$ Non$-$equality ioin: List all employees along with their salary grades based on their monthly salary. Use a non$-$equality ioin to determine which grade range their salary falls into. To do this you will need to join the employees table to the SalaryGrade table. $($You$\text{'}$ll need to upload JLDB$\_9.$sql and the SalaryGrade.sql file to do this$).$

$3.$ Self$-$Join: Identify employees who are managers along with their subordinates. $($This requires a self$-$ioin on the Employees table using the MGR and EMPNO fields$).$

$4.$ Outer$-$Join: List all publishers and the books they have published. Include publishers who currently have no books in the database.

$5.$ Set Operators: Retrieve a list of all authors who have either authored a book or are listed as contacts for any publisher without duplicates $($Use the UNION operator of the Author and Publisher tables$).$