MySqlでのcase when thenの使用

select "  ",  "    ", "    ","      ", "    ","    ","   "

union

(select
	pp.id as "  ",
	pp.project_number as "    ",  
	pp.name as "    ",
	pp.create_time as "      ",
	
	CASE WHEN pp.status = 'N' THEN '  '
	WHEN pp.status = 'T' THEN '  '
	WHEN pp.status = 'W' THEN '    '
	WHEN pp.status = 'QAS' THEN '    '
	WHEN pp.status = 'H' then '   '
	END as "    ",

	ppd.name as "    ",
	pu.login_name as "   "
from pmp_project pp
left join pmp_user pu on pp.create_user_id = pu.id
left join pmp_project_dept ppd on pp.project_line_id = ppd.id 
where pp.status != 'C'
order by s.id)