I have 3 tables Camp , Register, Receipt
Camp Register Receipt
camp id Name Category
camp name Camp Name Register No
camp date Reg No
Camp_name and Reg_no are primary key
how do i group camp by its name and also display the no of category in that particular camp.