Simple SQL Question

Hi,

[Quoted] 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 [Quoted] (indicated by bid) in more than one city.

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

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

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

Gracias,

Vinh
Montreal Received on Fri Mar 17 2000 - 00:00:00 CET