Question

Find customers who purchased ’Gruntmaster 6000’ and also ’Gruntmaster 9000’.

(a) select * from customer where purchased in (’Gruntmaster 6000’, ’Gruntmaster 9000’)

(b) select * from customer inner join purchaseitem on custid and description in (’Gruntmaster 6000’, ’Gruntmaster 9000’)

(c) select custid from purchase where description in (’Gruntmaster 6000’, ’Gruntmaster 9000’) 4

(d) select custid from purchase a inner join purchaseitem inner join purchase b inner join purchaseitem where a.description=’Gruntmaster 6000’ and b.description=’Gruntmaster 9000’

(e) Other:

Answer 1

Ans: E - other

A. is not correct because IN act like OR. it will pull data if one purchase 6000 or 9000.

B is incorrect syntax is incorrect.

C is incorrect because IN condition

D is incorrect because syntax error for inner join

Ans:

select * from customer where purchased = 'Gruntmaster 6000’ and purchased =’Gruntmaster 9000’;