pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
        




view thread (3+ messages)  latest in thread

Message-ID: <5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu>
Permalink:  ../5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu/
Also on:    postgresql.org/message-id/5.1.0.14.2.20011210121014.00a69038@acbell.mail.iastate.edu

 · 

reply

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