Snapshot of work on join query with frequency count.