Job three SQL statement query

Create three tables:

Clothing table:

Customer table:

Customer Record sheet:

3, (1) SELECT clothing number, model, color, price from clothing WHERE brand = ' Giordano ';

Results:

(2) SELECT customer. Name, phone from purchase record, customer WHERE purchase record. Clothing number = ' w004 ' and ' purchase record '. ' Customer number ' = ' customer '. ' Customer number ';

(3)

SELECT DISTINCT ' customers '. * from customer, ' purchase record ' WHERE customer. ' Customer number ' not in
(SELECT ' customer '. ' Customer number ' from Customer, ' purchase record ' WHERE customer. Customer number = purchase record. Customer number);

Results:

(4)

SELECT DISTINCT ' customers '. * from clothing, customers, purchase records WHERE ' clothing '. Brand = ' Giordano ' and ' purchase record '. ' Clothing number ' = ' costume '. ' Clothing number '
and customer. ' Customer number ' = ' purchase record '. ' Customer number ';

4, (1)

Job three SQL statement query