Extracting all cate_id's and the maximum 'book_price' in each group of 'cate_id'. �GROUP BY � clause have grouped 'cate_id's:

Category id	maximum book price
CA001	145.00
CA002	250.00
CA003	200.00
CA004	100.00
CA005	180.00