PART TWO $$ SQL practices$($challenges$)$

Question: Write five queries where you use any of the following joins:

$1.$ INNER JOIN

$2.$ LEFT OUTER JOIN

$3.$ RIGHT OUTER JOIN

$4.$ Full OUTER JOIN

For each query, you must:

$$ Come up with a scenario from the $$Student Schema$$ where this join would be necessary.

$$ Clearly state the question you are answering $($e$.$g$.,$ include the attribute you need to display$)$

$$ Write the SQL statement that solves the question.

$$ Provide the expected output based on the given data.

Rubric $(10$ points per query$)$:

$$ Scenario $(2$ points$)$: The scenario is realistic and clearly explains why this type of join is needed.

$$ Question $(2$ points$)$: The question clearly specifies which attributes to display

$$ SQL Statement $(3$ points$)$: The SQL query correctly implements the specified join with accurate syntax.

$$ Output $(3$ points$)$: The expected output is clearly shown and matches what the query would produce.

$$

Example Breakdown:

Example Scenario for LEFT OUTER JOIN:

$$ Scenario: You want to list all students and the sections they are enrolled in$,$ including students who have not yet enrolled in any section.

$$ Question: Display Student$\_$Id$,$ First$\_$Name, Last$\_$Name, and Section$\_$Id for all students.

$$

$$ SQL statement here

o xxx

$$ Output is here

o xxx