PubNub Interview Question

I remember an SQL challenge - joining tables.