Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Programming questions