create view TC as 
select `sv_posts`.`ID` AS `id`,
max((case when (`sv_postmeta`.`meta_key` = _utf8'student_name') then `sv_postmeta`.`meta_value` end)) AS `student_name`,
max((case when (`sv_postmeta`.`meta_key` = _utf8'scholar_no') then `sv_postmeta`.`meta_value` end)) AS `scholar_no`,
max((case when (`sv_postmeta`.`meta_key` = _utf8'tc_download') then `sv_postmeta`.`meta_value` end)) AS `tc_download` from (`sv_posts` 
join `sv_postmeta` on((`sv_postmeta`.`post_id` = `sv_posts`.`ID`))) 
where (`sv_posts`.`post_type` = _utf8'addtc') group by `sv_posts`.`ID`