Skip site navigation (1) Skip section navigation (2)

Re: Can anybody help me with SQL?

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 (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-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
        


In response to

pgsql-novice by date

Next:From: Josh BerkusDate: 2001-12-10 19:40:19
Subject: Re: odbc-connect
Previous:From: Oliver WalterDate: 2001-12-10 16:37:30
Subject: odbc-connect

pgsql-sql by date

Next:From: Roberto MelloDate: 2001-12-10 19:08:17
Subject: Re: anyone can help?
Previous:From: Nick FankhauserDate: 2001-12-10 18:10:38
Subject: Re: anyone can help?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group