Dear CSC3400 & CSC8500 students: In order to facilitate your own testing of our SQL answers to the questions in Assignment 2, I create a .sql file to help you quickly create the two tables involved, i.e. Contest and Debater. You can find this file under Assignment 2. You need to first download the .sql file to your local disc and use the Import facility of phpmyadmin interface to import the .sql file (See practicum 2). After that, you can see that these two tables are created and some records have been populated. You must use the tables to test the correctness of your SQL answers. I believe you will become more confident about your answers after testing them on the real tables. Note that, the keyword EXCEPT and INTERCEPT are not recognized in MySQL, so do not feel surprised if you find these keywords does not work in MySQL. I will recognize these keywords in my marking though. Regards! Ji