Question: Using the following schema, find all the information regarding the purchases of customer # 7 5 . ( No projections ) CREATE TABLE IF NOT

Using the following schema, find all the information regarding the purchases of customer #75.(No projections)
CREATE TABLE IF NOT EXISTS "purchase" (
productid mediumint default NULL,
customerid mediumint default NULL,
date varchar(255),
placebought varchar(100) default NULL
;
CREATE TABLE IF NOT EXISTS "customer" (
customerid mediumint,
email varchar(255) default NULL,
name varchar(255) default NULL,
postalZip varchar(10) default NULL,
phone varchar(100) default NULL
:
CREATE TABLE IF NOT EXISTS "product" (
productid mediumint,
price mediumint default NULL,
company varchar(255),
name TEXT default NULL,
color string(12) default NULL
 Using the following schema, find all the information regarding the purchases

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!