Assignment 3 - Presentation
Install MySQL Workbench on your PC
Please read instructions in the subject outline
Assignment 3 - Presentation of queries Step 1 After getting the correct answer to each question;
1. Copy and paste your SQL code into a Word document for each question, as the example below:
Q-1:
SELECT event_code
FROM prize
WHERE place=1
AND prizemoney BETWEEN 100 AND 200;
SQL Help, by: Antoinette Cevenini - 2016
Presentation of queries step 2 - Continued …
2. Do a screenshot (ALT+PRTSCN) of your SQL code and paste under the copied SQL code for each question into a Word document, as the example below: Q-1:
SELECT event_code
FROM prize
WHERE place=1
AND prizemoney BETWEEN 100 AND 200;
Step 2- The screenshot
SQL Help, by: Antoinette Cevenini - 2016
Presentation of queries step 3 Continued … 3. Copy the results only then paste under the screenshot in your Word document for each question, as shown below: Q-1:
SELECT event_code
FROM prize
WHERE place=1 AND prizemoney BETWEEN 100 AND 200;
event_code
0101
0103
Step 3- The results
SQL Help, by: Antoinette Cevenini - 2016
Presentation of queries- complete for each question Q-1:
SELECT event_code
FROM prize
WHERE place=1 AND prizemoney BETWEEN 100 AND 200;
event_code
0101
0103
Step 3- The results
Step 2- The screenshot
Step 1- The code
SQL Help, by: Antoinette Cevenini - 2016