Task 1(d) All products delivered to Schulze by Meier

Task Description:

Express following queries in SQL!

List all products that dealer Schmidt sold to customer Schulze.


Orders
Customer
Line_Item
Product
Dealer
OidDidDateCid
372002-12-0117
5112003-04-2723
752003-05-1317
1052003-09-0113
cidname
13M. Mueller
17A. Meier
23I. Schulze
OidPidAmount
3451
3675
5671
7573
7672
10452
10575
10673
PidLabel
45Steckernetzteil
57TP-Kabel
67Einbaukäfig
DidName
5G. Hals
7P. Schmidt
11E. Meier
13E. Mueller



Your Result: