From: Andrew Bell <acbell@iastate.edu>
To: pgsql-novice@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: Can anybody help me with SQL?
Date: Mon, 10 Dec 2001 12:10:41 -0600
Message-ID: <5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu> (raw)
In-Reply-To: <F113GXix4A2DreBBsQw000012d9@hotmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: acbell@iastate.edu, pgsql-novice@postgresql.org
Subject: Re: Can anybody help me with SQL?
In-Reply-To: <5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox