Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fATG8em75384 for ; Thu, 29 Nov 2001 11:08:40 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fATFssU02396 for pgsql-sql@postgresql.org; Thu, 29 Nov 2001 10:54:54 -0500 (EST) (envelope-from news) From: dejauser2001@yahoo.co.uk (dejauser2001@yahoo.co.uk) X-Newsgroups: comp.databases.postgresql.sql, mailing.database.sql-general, microsoft.public.it.sql Subject: Need help with a college SQL exam question... Date: 29 Nov 2001 07:54:52 -0800 Organization: http://groups.google.com/ Lines: 26 Message-ID: <383ef96c.0111290754.4ab26b07@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200112/22 X-Sequence-Number: 5845 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