Simple SQL Question

I have the following tables:

Employee (eid, ename, street, city)
Works (eid, bid, cname,salary)
Company (bid, cname,city)
Manages (eid, mid, bid, cname)

A company, which is uniquely identified by its cname, may have branches (indicated by bid) in more than one city.

Help me the write TWO appropriate queries that each satisfy the following requirements:

[Quoted] 1- Find the names of companies that are located IN EVERY CITY in which 'Bank of Trade' is located.

2-Make a list of the cities which have one of its residents as a manger IN EVERY COMPANY located in the city.

Gracias,

Vinh
Montreal Received on Sat Mar 18 2000 - 04:42:02 CET