select avg(field)
group by day
-----Original Message-----
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 4:18 PM
To: CF-Talk
Subject: RE: Average Orders Per Day
what DB?
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Nicholas Bourgeois [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 12:43 PM
To: CF-Talk
Subject: SQL: Average Orders Per Day
I need to construct a SQL statement to get the average number of orders per
day, but I can't figure it out.
The table name is "orderSummary" and the date field is named "ordDate."
Nick
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
