OIM2000 Aggregate Query Solutions

These flashcards cover key vocabulary terms related to aggregate queries, membership types, and database management as discussed in the OIM2000 lecture.

Aggregate Query

A query that groups records based on shared values and applies an aggregate function to one or more fields.

Aggregate Function

Mathematical operations like sum, count, or average that are applied to grouped data.

Class Registration

A record of individuals enrolling in classes along with details like ID, date of registration, and member information.

Membership Type

Different categories of gym memberships that may have distinct benefits and costs.

Monthly Dues

The regular fee charged for membership, specified on a monthly basis.

Babson Discount

A discount applied to the dues of Babson-affiliated members.

Query

A request for data or information from a database.

Count Query

A query that counts the total number of occurrences or entries.

Sum Query

A query that calculates the total sum of specified numeric values.

Group By

A SQL clause used to arrange identical data into groups.

Calculated Field

A field that derives its value from a calculation of other fields.