I have a column namely state, product now I tried to extract report state-wise like:
State Product Count
01 Paper 20
01 Pencil 200
02 Paper 50
02 Pen 100
Please help me to design query with top 100 count on State specific.