Re: Need help with a college SQL exam question...

"dejauser":

> Its coming close to my January examinations, and
> while revising I got stuck in the follwing question.
> I literally spent hours trying to solve it but I
> just can't :(

hmmm ... I don't think it's according to the honor code to ask us to
help with your exams.  ;-)

> And the question is;
> Using SQL (using SELECT, FROM, WHERE, GROUP BY, COUNT(*), etc..)
> write a query
> to list the names of customers who have borrowed cars made by every
> maker.

It's doable.  Just think "nested subselects" and heavy use of the HAVING
clause.  They're also screwing with you by providing an irrelevant table
(shop) and not providing a relevant table (makers).  If I was the
professor, I'd give the question writer a D+ for database design ...

-Josh

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco