You need count(*) of the transaction file divided by count(*) of the customer master. I can't see any way of doing that in one statement. Joe > From: Matthias Oertli > > Given a customer master file (one record per customer) and a transaction > file (one record per transaction, one customer can have many > transactions), how would it be possible to find the average number of > transactions per customer with one single SQL statement?
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact