CREATE TABLE `pr` (
  `group_code` int( 5 ) unsigned NOT NULL default '0',
  `pr_name` varchar( 255 ) NOT NULL default '',
  `pr_comm` int( 5 ) unsigned NOT NULL default '0'
);

INSERT INTO `pr` VALUES ( 14113 , 'Front', '1');
INSERT INTO `pr` VALUES ( 14113 , 'Front', '2');
INSERT INTO `pr` VALUES ( 14113 , 'Front', '3');

INSERT INTO `pr` VALUES ( 14113 , 'Back', '3');
INSERT INTO `pr` VALUES ( 14113 , 'Back', '2');

INSERT INTO `pr` VALUES ( 14114 , 'Bottom', '1');
INSERT INTO `pr` VALUES ( 14114 , 'Bottom', '3');
INSERT INTO `pr` VALUES ( 14114 , 'Up', '1');
INSERT INTO `pr` VALUES ( 14114 , 'Side', '3');

CREATE TABLE temp SELECT * FROM pr GROUP by pr_name ORDER by group_code DESC

SELECT group_code, count(group_code) FROM `temp` GROUP BY group_code