We have a marketing system that monitors campaign links clicked:
Contact | Link
===========
Larry | Link D
Nancy | Link A
John | Link B
Larry | Link A
Larry | Link A
Larry | Link C
Nancy | Link D
Nancy | Link D
Ideally I'd like a query that summarizes as follows:
Contact | Links clicked...