Question3

Question 3

Get pid values of products that are ordered by all customers who live in Dallas.

SQL:

    select distinct pid 
        from ord_order_line, customer
                where customer.cid=ord_order_line.cid
                  and customer.city = 'Dallas' ;

Output:

    PID
    ---
    p03
    p05

    2 record(s) selected.