Received: from mailhub-1.iastate.edu (mailhub-1.iastate.edu [129.186.140.3]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBAI9Cm85532; Mon, 10 Dec 2001 13:09:13 -0500 (EST) (envelope-from acbell@iastate.edu) Received: from SN174646.iastate.edu (pc101059.stat.iastate.edu [129.186.101.59]) by mailhub-1.iastate.edu (8.9.3/8.9.3) with ESMTP id MAA16627; Mon, 10 Dec 2001 12:09:01 -0600 Message-Id: <5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu> X-Sender: acbell@acbell.mail.iastate.edu (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Mon, 10 Dec 2001 12:10:41 -0600 To: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org From: Andrew Bell Subject: Re: Can anybody help me with SQL? In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200112/45 X-Sequence-Number: 2589 At 08:42 AM 12/10/2001 +0000, Richard Lockwood wrote: >4. Which customer averaged the most miles/day? (surname)(single rental) >5. Which customer averaged the least miles/day? (surname)(single rental) >6. Which customer had to wait for the previous renter to return the car? >(surname) >6. What % of rentals are for one day only? >7. Can cars be rented on a Sunday? (i.e. are there any?) (regno) >8. List the total amount of money paid to each garage during this period. >9. What is the average miles driven per day? This sounds like a homework problem to me :) -- Andrew Bell acbell@iastate.edu