Queries with Join and Where Practice

This dataset has information about seasons $1$ to $31$ of The Simpsons. Write SQL queries to satisfy the following information requests.

$1\mathrm{.}1$

Which episodes have won awards that begin with "Outstanding"?

Show season number, episode number, title, award category, and award name.

Sort the result by season number then by episode number

Be sure to remove any duplicates from the list.

$20$

$1\mathrm{.}2$

Which people have won awards in the category "Primetime Emmy" for playing characters?

Show the person's name, character, and award name.

Sort the result alphabetically by person then by character.

Be sure to remove any duplicates from the list.

Note: Sometimes the "person" receiving the award is a company. It is okay to include companies in the result.

$20$

$1\mathrm{.}3$

In which episodes has the character named "Rabbi Hyman Krustofski" appeared?

Show the episode ID$,$ number in series, and title.

Sort the results in descending order by the episode number in series

$20$

$1\mathrm{.}4$

What is the highest rated episode in which the character named "Apu Nahasapeemapetilon" appears?

Show the episode id$,$ title, airdate, and rating

$20$

$1\mathrm{.}5$

Which episodes have award$-$winning songs?

Show the episode id$,$ title and name of the song.