Question: Instructions If you don't already have it, install the SQLite Browser from http://sqlitebrowser.org/ Then, create a SQLITE database or use an existing database and create

Instructions If you don't already have it, install the SQLite Browser from http://sqlitebrowser.org/ 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 ('Keeman', 22); INSERT INTO Ages (name, age) VALUES ('Seane', 28); INSERT INTO Ages (name, age) VALUES ('Maliha', 39); INSERT INTO Ages (name, age) VALUES ('Aedan', 17); INSERT INTO Ages (name, age) VALUES ('Aya', 36); INSERT INTO Ages (name, age) VALUES ('Cristian', 16); 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. Instructions If you don't already have it, install the SQLite Browser from http://sqlitebrowser.org/ 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 ('Keeman', 22); INSERT INTO Ages (name, age) VALUES ('Seane', 28); INSERT INTO Ages (name, age) VALUES ('Maliha', 39); INSERT INTO Ages (name, age) VALUES ('Aedan', 17); INSERT INTO Ages (name, age) VALUES ('Aya', 36); INSERT INTO Ages (name, age) VALUES ('Cristian', 16); 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
Get step-by-step solutions from verified subject matter experts
