RE: Elementary SQL question

[rob@xxxxxxxxx]

And what about the customers with no transactions?

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.



                    "Rolf Mittag"
                    <rm@r-m-e-d-v.de>         To:     <midrange-l@midrange.com>
                    Sent by:                  cc:
                    midrange-l-admin@mi       Fax to:
                    drange.com                Subject:     RE: Elementary SQL 
question


                    09/21/2001 02:20 AM
                    Please respond to
                    midrange-l






out of my mind, not tested as I have no such files at hand

select <CustomerNumber>, avg(count(*)) from <transactionFile>
   group by <CustomerNumber>
   order by <CustomerNumber>

replace names within <> with the correct ones

hth Rolf

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dipl.Inf.(FH) Rolf P Mittag
IBM Partner in Development
Leipziger Str. 50
D-69214 Eppelheim
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26
eMl: rm@r-m-e-d-v.de
~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.