Question1

Question 1

Get agent id value, aid, for agents not taking orders from any customer in Duluth for any product in Dallas.

SQL:

    select aid 
        from agent 
        where aid not in (
            select distinct aid
                from ord_order_line ool, customer, product
                where ool.cid = customer.cid
                    and ool.pid = product.pid
                    and customer.city = 'Duluth'
                    and product.city = 'Dallas');

Output:

There was no output; all agents have taken such orders.

mj (Sep 14, 2001 9:39 pm; Comment #1)

I'll kick off with this one.