[john_the_writer]

Distinct, union, with, and case.. windowing. I'd suspect even joins (inner vs outer) would be really hard to articulate in a prompt.