Link to home
Start Free TrialLog in
Avatar of Victor Nares
Victor NaresFlag for United States of America

asked on

Using Aggregate Functions to Count

Thank you all in advance!

We have the following data:

audit_ID, DataPoint,   LocID
1                      y             MED
1                     Y              MED
1                     N             MED
1                      N             MED
2                      Y             ALC
2                      N            ALC
2                      N             ALC
2                      Y              ALC
3                      Y              MED
3                      N              MED
3                      N             MED
3                      N              MED


We would like the query to return:

LocID                         Number of Audits Submitted
MED                                                   2
ALC                                                     1

would prefer to use an aggregate function



Thanks in advance!
ASKER CERTIFIED SOLUTION
Avatar of _agx_
_agx_
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the above does not work for you, any chance you can spell out the logic for how the return set is generated?  We hate to guess.
Avatar of Victor Nares

ASKER

This worked great!

Thank you very much!!!