We have a table with user entered queries, their IP. How could we write a query that will count and order queries by their count having a unique IP count > X. For example if we had the same IP enter the same query Y times we wouldnlt want to include this in the final result unless there have been X-Y other IP's that searched for that query.
Is this perhaps better suited fro Pig? Thanks
