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