SQL Statement: Craft the appropriate SQL command to address the specified query. Ensure your

command is correctly formatted and free of errors.

II$.$ Outcome Documentation: After executing your SQL command, capture a screenshot of the

results. Ensure the screenshot is clear, showing both the query you've executed and its respective

outcome.

$7.$ Advance Queries:

For each department, find the instructor who earns the highest salary.

a$.$ Find all students who have taken more than three courses in a single semester.

b$.$ List the courses that have the highest number of prerequisites.

c$.$ Determine which room in each building has the highest capacity.

$8.$ Joins, Natural Joins, and Outer Joins:

b$.$ Using a NATURAL JOIN, retrieve all sections that were taught by instructor 'Kim'.

c$.$ Find all instructors and the courses they have taught, and include those who haven't taught any courses using

an OUTER JOIN

$9.$ Functions:

a$.$ Create a function that takes an instructor's ID and returns the total number of courses they have taught.

b$.$ Write a function to find the student with the highest total credits in a given department.