Sql语句将0，1转化为男女性别

SELECT
	id,
	user_cid,
	phone,
	name,
CASE
		gender 
		WHEN '1' THEN
		'男' 
		WHEN '2' THEN
		'女' 
	END AS gender,
	start_city,
	end_city,
	story,
	create_time 
FROM
	active_collection_story 
WHERE
	create_time BETWEEN '2019-01-25 00:00:00' 
	AND '2019-01-27 23:59:59';

select province,count(*) from table 
where type = '1' 
and create_time NOT BETWEEN '2019-05-16 00:00:00' AND '2019-05-17 00:00:00'
and create_time <  '2019-05-21 16:46:42' 
group by province;