SELECT count(*) ,  avg(age) ,  city_code FROM student WHERE sex  =  'M' GROUP BY city_code
SELECT count(*) ,  avg(age) ,  city_code FROM student WHERE sex  =  'M' GROUP BY city_code <table_name> : Student col : StuID | LName | Fname | Age | Sex | Major | Advisor | city_code row 1 : 1001 | Smith | Linda | 18 | F | 600 | 1121 | BAL row 2 : 1002 | Kim | Tracy | 19 | F | 600 | 7712 | HKG row 3 : 1003 | Jones | Shiela | 21 | F | 600 | 7792 | WAS row 4 : 1004 | Kumar | Dinesh | 20 | M | 600 | 8423 | CHI row 5 : 1005 | Gompers | Paul | 26 | M | 600 | 1121 | YYZ row 6 : 1006 | Schultz | Andy | 18 | M | 600 | 1148 | BAL row 7 : 1007 | Apap | Lisa | 18 | F | 600 | 8918 | PIT row 8 : 1008 | Nelson | Jandy | 20 | F | 600 | 9172 | BAL row 9 : 1009 | Tai | Eric | 19 | M | 600 | 2192 | YYZ row 10 : 1010 | Lee | Derek | 17 | M | 600 | 2192 | HOU row 11 : 1011 | Adams | David | 22 | M | 600 | 1148 | PHL row 12 : 1012 | Davis | Steven | 20 | M | 600 | 7723 | PIT row 13 : 1014 | Norris | Charles | 18 | M | 600 | 8741 | DAL row 14 : 1015 | Lee | Susan | 16 | F | 600 | 8721 | HKG row 15 : 1016 | Schwartz | Mark | 17 | M | 600 | 2192 | DET row 16 : 1017 | Wilson | Bruce | 27 | M | 600 | 1148 | LON row 17 : 1018 | Leighton | Michael | 20 | M | 600 | 1121 | PIT row 18 : 1019 | Pang | Arthur | 18 | M | 600 | 2192 | WAS row 19 : 1020 | Thornton | Ian | 22 | M | 520 | 7271 | NYC row 20 : 1021 | Andreou | George | 19 | M | 520 | 8722 | NYC row 21 : 1022 | Woods | Michael | 17 | M | 540 | 8722 | PHL row 22 : 1023 | Shieber | David | 20 | M | 520 | 8722 | NYC row 23 : 1024 | Prater | Stacy | 18 | F | 540 | 7271 | BAL row 24 : 1025 | Goldman | Mark | 18 | M | 520 | 7134 | PIT row 25 : 1026 | Pang | Eric | 19 | M | 520 | 7134 | HKG row 26 : 1027 | Brody | Paul | 18 | M | 520 | 8723 | LOS row 27 : 1028 | Rugh | Eric | 20 | M | 550 | 2311 | ROC row 28 : 1029 | Han | Jun | 17 | M | 100 | 2311 | PEK row 29 : 1030 | Cheng | Lisa | 21 | F | 550 | 2311 | SFO row 30 : 1031 | Smith | Sarah | 20 | F | 550 | 8772 | PHL row 31 : 1032 | Brown | Eric | 20 | M | 550 | 8772 | ATL row 32 : 1033 | Simms | William | 18 | M | 550 | 8772 | NAR row 33 : 1034 | Epp | Eric | 18 | M | 50 | 5718 | BOS row 34 : 1035 | Schmidt | Sarah | 26 | F | 50 | 5718 | WAS
col : count(*) | avg(age) | city_code row 1 : 1 | 20.0 | ATL row 2 : 1 | 18.0 | BAL row 3 : 1 | 18.0 | BOS row 4 : 1 | 20.0 | CHI row 5 : 1 | 18.0 | DAL row 6 : 1 | 17.0 | DET row 7 : 1 | 19.0 | HKG row 8 : 1 | 17.0 | HOU row 9 : 1 | 27.0 | LON row 10 : 1 | 18.0 | LOS row 11 : 1 | 18.0 | NAR row 12 : 3 | 20.3333333333 | NYC row 13 : 1 | 17.0 | PEK row 14 : 2 | 19.5 | PHL row 15 : 3 | 19.3333333333 | PIT row 16 : 1 | 20.0 | ROC row 17 : 1 | 18.0 | WAS row 18 : 2 | 22.5 | YYZ