Question: Using the following schema, determine the customer name, product name, and product price of all the purchases from Ukraine. CREATE TABLE IF NOT EXISTS purchase
Using the following schema, determine the customer name, product name, and product price of all the purchases from Ukraine.
CREATE TABLE IF NOT EXISTS "purchase"
productid mediumint default NULL,
customerid mediumint default NULL,
date varchar
placebought varchar default NULL
;
CREATE TABLE IF NOT EXISTS "customer"
customerid mediumint,
email varchar default NULL,
name varchar default NULL,
postalZip varchar default NULL,
phone varchar default NULL
:
CREATE TABLE IF NOT EXISTS "product"
productid mediumint,
price mediumint default NULL,
company varchar
name TEXT default NULL,
color string default NULL
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
