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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco