Need help with a college SQL exam question...

From: dejauser2001(at)yahoo(dot)co(dot)uk (dejauser2001(at)yahoo(dot)co(dot)uk)
To: pgsql-sql(at)postgresql(dot)org
Subject: Need help with a college SQL exam question...
Date: 2001-11-29 15:54:52
Message-ID: 383ef96c.0111290754.4ab26b07@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi everyone,

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 :(

Consider the folowing relations; (where the * means
primary key)

The "Car Rental" database
-------------------------

customer(*cust_num*,cust_name)
hire(*car_reg*,*cust_num*,*hire_date*)
shop(*outlet_code*,address)
car_model(*model*,make,num_seats,max_speed)
car(*car reg*,model,year, outlet_code)

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.

Thats it! Hard or what?

Any help greatly apreciated

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Haller Christoph 2001-11-29 15:58:33 Re: Check for table existence
Previous Message Markus Bertheau 2001-11-29 14:36:58 Re: Fixing faulty dates - select on day part of a date field