Question: To get credit for this assignment, perform the instructions below and enter the code you get here: (Hint: starts with 446) Instructions If you don't

To get credit for this assignment, perform the instructions below and enter the code you get here: (Hint: starts with 446)

Instructions

If you don't already have it, install the SQLite Browser.

Then, create a SQLITE database or use an existing database and 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 ('Siddharth', 25); INSERT INTO Ages (name, age) VALUES ('Suranne', 17); INSERT INTO Ages (name, age) VALUES ('Wilson', 32); INSERT INTO Ages (name, age) VALUES ('Marcos', 21); INSERT INTO Ages (name, age) VALUES ('Dexter', 15); INSERT INTO Ages (name, age) VALUES ('Emelie', 38); 

Once the inserts are done, run the following SQL command:

SELECT hex(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 53656C696E613333.

Note: This assignment must be done using SQLite - in particular, the SELECT query above will not work in any other database. So you cannot use MySQL or Oracle for this assignment.

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!