Compulsory Task $1$

Answer the following questions:

$$ Go to the JDoodle Online SQL IDE. This is where you can write and test your SQL code using their databases. Once you are happy with your code, paste it into a text file and save the file in your task folder as Student.txt$.$

$$ Write the SQL code to create a table called Student. The table structure is summarised in the table below.

Note that STU$\_$NUM must be set up as the primary key.