In Project Task $3,$ you are required to write $12$ SQL queries based on the tables from the provided relational model Download relational model.

These queries are detailed in the task$-3.$sql Download task$-3.$sqlfile, along with their corresponding scores.$$

All table names, attribute names, primary keys, and foreign keys are specified exactly as shown in the relational model Download relational model.

Please fill in your answers in the designated spaces within the task$-3.$sql Download task$-3.$sqlfile, and submit it on or before the deadline.

Do not modify any of the provided SQL queries in the task$-3.$sql Download task$-3.$sqlfile.

Your answers should consist of SQL queries covered in this course $($in slides or introduced in class$).$

Each query will be evaluated as follows: correct $($full mark$),$ partially correct $($half mark$),$ or incorrect $($zero mark$).$ A query is considered correct if it produces the expected output from our test cases. The decision on whether a query is partially correct or incorrect will be made by the grader.

Before submitting, carefully verify that your SQL queries are executable and yield the correct output.

In addition to creating your own tables for testing, further methods for testing your SQL queries will be provided later.

$($I am checking whether the university supports specific database servers for you to connect to test your SQL queries, rather than providing you with the table creation code. Providing the table creation code will be a last resort if no other options are available. I will update for this soon.$)$

Important Notes:

The date format in Oracle is $"$dd MMM yyyy$"($e$.$g$.,"20$ Dec $2024").$ In MySQL$,$ it is $"$yyyy$-$mm$-$dd$"($e$.$g$.,"2024-12-20").$ Your answers should follow the Oracle standard.

Member$\_$Fee, Non$\_$Member$\_$Fee, Quota, etc., are numeric values.

The data type for Gender in the REGISTERED$\_$USER table is CHAR$(1),$ which can have a value of either $\text{'}$M$\text{'}$ for male or $\text{'}$F$\text{'}$ for female, and it cannot be NULL.

Attached is the relation model.

Below is the SQL task$3.$

$/$Do not modify any provided SQL statements.

Please enter your SQL queries in the designated spaces.

Run your SQL queries to verify that they are free of errors..

$*/$

SELECT $\text{'}----$ QUERY $1----\text{'}$ FROM DUAL;

$/*$

ToDo $1.(5$ points$)$

Retrieve the event venues and member fees for events held between $2$ Jan $2020$

and $31$ Dec $2020.$

The result set should not include duplicate rows for the same venue and

member fee.

Please enter your SQL query in the space below, ABOVE the line of SELECT

$\text{'}----$ QUERY $2----\text{'}$ FROM DUAL;

$*/$

SELECT $\text{'}----$ QUERY $2----\text{'}$ FROM DUAL;

$/*$

ToDo $2.(5$ points$)$

Retrieve the event name, date, time, and venue for events where the member

fee is greater than

or equal to $50$ but less than $100,$ or where the non$-$member fee is greater than

$200$ but less than $250.$

Please enter your SQL query in the space below, ABOVE the line of SELECT

$\text{'}----$ QUERY $3----\text{'}$ FROM DUAL;

$*/$

SELECT $\text{'}----$ QUERY $3----\text{'}$ FROM DUAL;

$/*$

ToDo $3.(5$ points$)$

Retrieve the names of all events along with the names of their corresponding

supervisors.

Please enter your SQL query in the space below, ABOVE the line of SELECT

$\text{'}----$ QUERY $4----\text{'}$ FROM DUAL;

$*/$

SELECT $\text{'}----$ QUERY $4----\text{'}$ FROM DUAL;

$/*$

ToDo $4.(5$ points$)$

Retrieve the names and dates of all events, ordered by date in ascending

order.

Please enter your SQL query in the space below, ABOVE the line of SELECT

$\text{'}----$ QUERY $5----\text{'}$ FROM DUAL;.

$*/$

SELECT $\text{'}----$ QUERY $5----\text{'}$ FROM DUAL;

$/*$

ToDo $5.(10$ points$)$

Retrieve the event names and the names of supervisors for events that are supervised by employees

managing at least one of the fan clubs hosting the event. Please enter your SQL query in the space below.

U

$```$

$/*$

Do not modify any provided SQL statements.

Please enter your SQL queries in the designated spaces.

Run your SQL queries to verify that they are free of errors.

$*/$

$```$

SELECT $\text{'}----$ QUERY $1----\text{'}$ FROM DUAL;

$/*$

ToDo $1.(5$ points$)$

Retrieve the event venues and member fees for events held between $2$ Jan $2020$

and $31$ Dec $2020.$

The result set should not include duplicate rows for the same venue and

member fee.

Please enter your SQL query in the space below, ABOVE the line of SELECT

$\text{'}----$ QUERY $2----\text{'}$ FROM DUAL;

$*/$

SELECT $\text{'}----$ QUERY $2----\text{'}$ FROM DUAL;

$/*$

ToDo $2.(5$ points$)$

Retrieve the event name, date, time, and venue for events where the member

fee is greater than

or equal to $50$ but less than $100,$ or where the non$-$member fee is greater than

$200$ but less than $250.$

Please enter your SQL query in the space below, ABOVE the line of SELECT

$\text{'}----$ QUERY $3----\text{'}$ FROM DUAL;

$*/$

SELECT $\text{'}----$ QUERY $3----\text{'}$ FROM DUAL;

$/*$

ToDo $3.(5$ points$)$

Retrieve the names of all events along with the names of their corresponding

supervisors.

$```$

Please enter your SQL query in the space below, ABOVE the line of SELECT

$\text{'}----$ QUERY $4----\text{'}$ FROM DUAL;

$*/$

$```$

SELECT $\text{'}----$ QUERY $4----\text{'}$ FROM DUAL;

$/*$

ToDo $4.(5$ points$)$

Retrieve the names and dat