Tricky SQL

From: <pmcadam_at_my-deja.com>
Date: Wed, 22 Nov 2000 18:12:09 GMT
Message-ID: <8vh29h$1co$1@nnrp1.deja.com>

OK all you SQL Gods out there. Can you answer this one.

table employee:
employeeid(PK), name, companyid(FK)

table company:
companyid(PK) , name

table department:
departmentid(PK) , name, companyid(FK)

· Write a query to list all the department names from all companies that (the companies) have more than 25 employees and that (the company) have a name that starts with an 'A'.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 22 2000 - 12:12:09 CST