Question: CREATE TABLE customer ( id INTEGER PRIMARY KEY, customer_name TEXT, contact_number TEXT ); CREATE TABLE supplier ( id INTEGER PRIMARY KEY, supplier_name TEXT UNIQUE, contact_number

CREATE TABLE customer (

id INTEGER PRIMARY KEY,

customer_name TEXT,

contact_number TEXT

);

CREATE TABLE supplier (

id INTEGER PRIMARY KEY,

supplier_name TEXT UNIQUE,

contact_number TEXT

);

CREATE TABLE product (

id INTEGER PRIMARY KEY,

supplier_id INTEGER REFERENCES supplier(id),

product_name TEXT,

product_price INTEGER,

UNIQUE(supplier_id, product_name)

);

CREATE TABLE purchase (

id INTEGER PRIMARY KEY,

customer_id INTEGER REFERENCES customer(id),

purchase_date REAL,

store_id INTEGER REFERENCES store(id)

);

CREATE TABLE store (

id INTEGER PRIMARY KEY,

store_name TEXT,

store_address TEXT

);

CREATE TABLE purchase_product (

purchase_id INTEGER REFERENCES purchase(id),

product_id INTEGER REFERENCES product(id),

quantity INTEGER

);

  1. List the names of all customers who have purchased a product that could have been purchased from a supplier with a lower price by at least 5 dollars

    (500 cents), ordered by customer_name

  2. List the names of all customers who purchased Tool 1717 and then later purchased O-Ring 1736, ordered by customer name.

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!