troubleshooting Question

count transactions within a query

Avatar of NiceMan331
NiceMan331 asked on
Oracle Database
27 Comments2 Solutions278 ViewsLast Modified:
hi
reference to this question
https://www.experts-exchange.com/Database/Oracle/Q_28553461.html

i feel shame to add another requirement to same question , so i opened a new topic
the sql of slightw will retrieve the sum of transactions amount within a month or a week
ok , now let do more description
in every day , there are many transactions for each store
here i got for example : sum of Mar for store # 01 = 2500 $
and that store works only 25 days , it means no data in 6 days from Mar
so the daily average for that store will be : 2500 / 25  ,  not 2500/31
how i  get the count of transaction per store group by DOB , to get the daily average per store in the same query
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 27 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 27 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros