Tuple/Domain Calculus Functions
In tuple/domain calculus, can I use the functions AVERAGE, COUNT, SUM, MAXIMUM, and MINIMUM, or do I need to do something else?
Who is Participating?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
you typically use them in conjunction with groupings
so, for example, if you want a list of employees and their total expenses, it'd look like
select employeeid, sum(expense) from expenses group by employeeid