Re: [NOVICE] Can anybody help me with SQL? - Mailing list pgsql-sql

From Andrew Bell
Subject Re: [NOVICE] Can anybody help me with SQL?
Date
Msg-id 5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu
Whole thread Raw
In response to Can anybody help me with SQL?  ("Richard Lockwood" <rickardo2010@hotmail.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Can anybody help me with SQL?
Next
From: sharmad@goatelecom.com
Date:
Subject: Indices