Instructions: 1. Use Notepad to write the MySQL commands for completing this Test.
2. Test all queries on MySQL Workbench for correct output.
3. Start all Queries by typing the Query Number and short description using # sign as first character to make it a comment.
4. There should be no blank line between query or comments.
5. Save the test as Test2_firstName. txt.
6. Submit on D2L Drop box.
7. If you are not sure how to complete any query, type the Query number and “I cannot complete this query” as comments.
8. Any query generating an error will not be graded for partial credit.
9. All suggested variable name and output columns are in bold letters.
10. Use meaningful appropriate column names if none is suggested. Two point will be deducted for each query output with command or function/expression as column name and not appropriate or suggested column name.

1. Store your full name in a memory variable name.

SQL Command:

2. Display your name using the above memory variable as Hands-on-Test2 Submitted by.

SQL Command:

3. Display the following information from the score table using group by event_id.

SQL Command:

…… continued on next page

4. Display the following records from the student table using the limit option.

SQL Command:

5. Suppose that May 11, 2021 is the Graduation Day. Use the February 20, 2021 as the date with date_format function and date_add function( day as interval) to display the Date of Graduation as Graduation Date. Sample Output is shown below

SQL Command:

6. Store 5.59 as radius in the memory.

SQL Command:

7. Use the above stored variable to compute and display the area as AREA, rounded to two places of decimal. Note: You must use the power function, PI function and Round Function. Sample output.

SQL Command:

…… continued on next page

8. Display Current Date and Time, My Date of Birth, I was born on using the functions now function, date_format(“your cdate_of_birth”, ‘ enter the format here’) , dayname function(“your date of birth) to display the output as shown below (sample):

SQL Command:

9. Using System date and date format to display Today’s date as Today’s Date, your date of Birth using date format as I was born on, and compute your age using any function(s) and your date of birth as I am, rounded to two decimal places with the text years old add to your age in figures. See the given sample.

SQL Command:

10. A quotation “A Thing of Beauty is a Joy for Ever” has been stored in a memory variable Quotation. Use substring function and upper case function to display the Quotation as “Famous Quotation”, and the text Beauty as “Sub String” as shown below:

SQL Command:

Needs to be completed in sql and then pasted in notepad. please help!