Question
1 3 Instructions: Create MySQL Queries for each task. 2. Copy and past the MySQL Query from MySQL Workbench. 3. Copy and past the output
1 3 Instructions: Create MySQL Queries for each task. 2. Copy and past the MySQL Query from MySQL Workbench. 3. Copy and past the output of each query below the query. Use Windows Snip and Sketch program. 4. Use meaningful appropriate column names if none is suggested. Two points 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: Output: 3. Display the following information from the score table using group by event_id. event manage sunt 20 15.139 >> + 20 2030 23 SQL Command: Output: Display the following records from the student table using the limit option 14 1 SQL Command: Output: 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 LI SOL Command Output: Store 5.59 as radius in the memory SQL Command: 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, Pl function and Round Function Sample output ARA SQL Command: Output: 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): SOL Command Output: 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 functions) 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 SOL Command: Output: 1. 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: Output: ***End of Test ******
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started