•Based on Group
Membership
–Show me the average balance of new savings accounts opened by recipient’s on January’s Super-Saver
mailing
•SQL
–Create a study group
table – households part of the Super-Saver mailing
–Join the study group
table to the fact table
•Application
•Set Operations –
union, intersect, minus – reduce complexity and
increase performance
•