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: (view raw or whole 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? 
>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

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-2015 The PostgreSQL Global Development Group