Assignment Elementary SQL
This exercise is based on the folder called Inclassexercise available in Moodle. Export all four tables to excel files, then create these tables and input all values to your MySQL database. Write SQL statements to answer the following queries.
In MySQL, add a course with a course ID of QMDS 200 and name Operations Research into the course table respectively.
SQL:
SQL:
Remove the course Business Mathematics from the course table.
SQL:
Find the name of the faculty member whose ID is 4756.
SQL:
Find the smallest section number used in the first semester of 2008 I2008.
SQL:
Find the age of the youngest nonlocal student age only, no need to show the corresponding name; nonlocal means nationality is not Macao.
SQL:
Find for each department whose youngest nonlocal student is not less than 19.
SQL:
SQL:
SQL:
SQL: