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 p$.*,$ pr$.*$

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 i get is that i get product id twice what should i do