DBC-SS21

Task 1(e).2 Products Mueller /Schulze

Task Description:

Express following queries in SQL!

Get all products that dealer Mueller sold and customer Schulze bought. (Intersection of Products)

Hints

Product

Dealer

Line_Item

Orders

Customer

Pid	Label
45	Steckernetzteil
57	TP-Kabel
67	Einbaukäfig

Did	Name
5	G. Hals
7	P. Schmidt
11	E. Meier
13	E. Mueller

Oid	Pid	Amount
3	45	1
3	67	5
5	67	1
7	57	3
7	67	2
10	45	2
10	57	5
10	67	3

Oid	Did	Date	Cid
3	7	2002-12-01	17
5	11	2003-04-27	23
7	5	2003-05-13	17
10	5	2003-09-01	13

cid	name
13	M. Mueller
17	A. Meier
23	I. Schulze

Your Result: