| From: | Andrew Bell <acbell(at)iastate(dot)edu> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Can anybody help me with SQL? |
| Date: | 2001-12-10 18:10:41 |
| Message-ID: | 5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice 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(at)iastate(dot)edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2001-12-10 19:40:19 | Re: odbc-connect |
| Previous Message | Oliver Walter | 2001-12-10 16:37:30 | odbc-connect |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Mello | 2001-12-10 19:08:17 | Re: anyone can help? |
| Previous Message | Nick Fankhauser | 2001-12-10 18:10:38 | Re: anyone can help? |