Write down the following queries in SQL:

$($i$)$ Display a list of all instructors, showing each instructor$$s ID and the number of

sections taught. Make sure to show the number of sections as $0$ for instructors who

have not taught any section. Your query should use an outer join, and should not use

subqueries.

$($ii$)$ Display the list of all departments, with the total number of instructors in each

department, without using subqueries. Make sure to show departments that have no

instructors, and list those departments with an instructor count of zero.