Parse JSON using mysql

parse json

/*

{"age":"Over 30","gender":"female"}
{"age":"Under 30","gender":"female"}
{"age":"Over 30","gender":"male"}
{"age":"Under 30","gender":"male"}

*/

select common_schema.extract_json_value(f.event_data,'/age') as age,
common_schema.extract_json_value(f.event_data,'/gender') as gender,
sum(f.event_count) as event_count 
from json_event_fact f
group by age, gender;

/*

+----------+---------+-------------+
| age      | gender  | event_count |
+----------+---------+-------------+
| Over 30  | female  |     3710983 |
| Over 30  | male    |     2869302 |
| Under 30 | female  |     5027591 |
| Under 30 | male    |     4918382 |
| unknown  | female  |       42039 |
| unknown  | male    |       50173 |
| unknown  | unknown |        8372 |
+----------+---------+-------------+

*/