MYSQL按组显示总和和状态

我有这样的桌子。。。

 ==========================================
 id | state       | fieldKey
 ==========================================
 1  | Florida     | property_state
 2  | Idaho       | property_state
 3  | Florida     | property_state
 4  | Ohio        | property_state
 5  | Oregon      | property_state
 6  | California  | property_state
 7  | California  | property_state
 8  | California  | property_state

以下是我的查询,但不起作用:

 select sum(id), state from ProjectFieldValue where fieldKey = 'property_state' group by fieldKey

下面是我想要输出的:

 2, Florida
 1, Idaho
 1, Ohio
 1, Oregon
 3, California

谢谢!