Query Groups

• To answer: “To which groups does Norman Horowitz belong” you do (join 3 tables)

select user_groups.group_name
        from users, user_groups, user_group_map
        where users.first_names = 'Norman' and users.last_name = 'Horowitz'
                and users.user_id = user_group_map.user_id
                and user_groups.user_group_id = user_group_map.user_group_id;