Victor Nares
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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
This worked great!
Thank you very much!!!
Thank you very much!!!