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

$)$; SELECT

pr$.$productid AS productid,

p$.$customerid,

p$.$date,

p$.$placebought,

pr$.$price,

pr$.$company,

pr$.$name,

pr$.$color

FROM

purchase p

JOIN

customer c ON p$.$customerid $=$ c$.$customerid

JOIN

product pr ON p$.$productid $=$ pr$.$productid

WHERE

c$.$customerid $=75$; the problem it has to be in that same order and i dont see the to ge in that order specifically like in the imge