Question: Your code did not match Welcome Vishvesh R from Introduction to Structured Query Language ( SQL ) To get credit for this assignment, perform the

Your code did not match
Welcome Vishvesh R from Introduction to Structured Query Language (SQL)
To get credit for this assignment, perform the instructions below and enter the code you get from the instructions below here (Hint: starts with 793)
Instructions
First, create a MySQL database or use an existing database (make sure to use a UTF8 character set, like utf8mb4) and then create a table in the database called "Ages":
CREATE TABLE Ages (
'name' VARCHAR(128),
age INTEGER
;
Then make sure the table is empty by deleting any rows that you previously inserted, and insert these rows and only these rows with the following commands:
DELETE FROM Ages;
INSERT INTO Ages ('name', age) VALUES ('Mykie',17);
INSERT INTO Ages ('name', age) VALUES ('Brenae',14);
INSERT INTO Ages ('name', age) VALUES ('Truli',19);
INSERT INTO Ages ('name', age) VALUES ('Constance',14);
Once the inserts are done, run the following SQL command:
SELECT sha1(CONCAT(' name', age)) AS X FROM Ages ORDER BY X;
Find the first row in the resulting record set and enter the long string that looks like 254c6127cdbc4c38e065317667340e8b0950046f (this is just a sample string).
 Your code did not match Welcome Vishvesh R from Introduction to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!