Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 3

blur-text-image

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

Database Fundamentals Study Guide

Authors: Dr. Sergio Pisano

1st Edition

B09K1WW84J, 979-8985115307

More Books

Students also viewed these Databases questions