pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Lockwood <rickardo2010@hotmail.com>
To: pgsql-novice@postgreSQL.org
To: pgsql-sql@postgreSQL.org
Subject: Can anybody help me with SQL?
Date: Mon, 10 Dec 2001 08:42:58 +0000
Message-ID: <F113GXix4A2DreBBsQw000012d9@hotmail.com> (raw)

Hi

I was wondering if anyone could help me with the following SQL questions:


1.Which car was rented for the longest single period? (regno)

SELECT regno, MAX(datein-dateout) "Longest Single Period" FROM rental group 
by regno;

Although this works - it shows ALL the regno's longest periods - how would i 
just display the regno?

2. Which car was rented for the longest total period? (regno)
3. Which customers (if any) were born on Monday? (surname)

For this question i thought that this would work:

SELECT * FROM cust WHERE TO_CHAR(cd_o_b,'DAY') = 'MONDAY'

But it never works - it says 'no rows selected'
although there are 2 cusotmers born on Monday
However if you put wednesday instead of monday or any other day it seems to 
work correctly
Anyone know why this is?

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?

The rest of the questions just baffle me as i cannot work them out at all.

If you can give me any help at all it would be very much appreciated!

The data/tables are defined below:

SERVICE
regno
gid
sdate
smileage
scost
servrep

CAR
regno
model_id
curr_milge
next_serv
cyear
colour

MODEL
model_id
make
unit_price
mileage_da

REPLACE
regno
gid
pno

PART
partno
pdesc

RENTAL
hireno
regno
rentalno
dateout
datein
milesout
milesin
cost

CUST
custno
cname
cname_1
cadd_1
ccode
cd_o_b

GARAGE
gid
gname
gadd

Any help would be very much appreciated!

Thanks

Rickardo


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp




view thread (3+ messages)  latest in thread

Message-ID: <F113GXix4A2DreBBsQw000012d9@hotmail.com>
Permalink:  ../F113GXix4A2DreBBsQw000012d9@hotmail.com/
Also on:    postgresql.org/message-id/F113GXix4A2DreBBsQw000012d9@hotmail.com

 · 

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: rickardo2010@hotmail.com, pgsql-novice@postgreSQL.org
  Subject: Re: Can anybody help me with SQL?
  In-Reply-To: <F113GXix4A2DreBBsQw000012d9@hotmail.com>

* 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