我想建立视图列有主诉，现病史，既往史，数据如下图所示都在一列，该如何操作

不懂医疗系统的业务；
应用逻辑如下：
SELECT
ID,
MAX(IF(WJJGMC REGEXP '主诉',WJJGMC,NULL)) AS GMC主诉,
MAX(IF(WJJGMC REGEXP '现病史',WJJGMC,NULL)) AS GMC现病史,
MAX(IF(WJJGMC REGEXP '既往史',WJJGMC,NULL)) AS GMC既往史,
MAX(IF(WJJGXSMC REGEXP '主诉',WJJGXSMC ,NULL)) AS GMC主诉,
MAX(IF(WJJGXSMC REGEXP '现病史',WJJGXSMC ,NULL)) AS GMC现病史,
MAX(IF(WJJGXSMC REGEXP '既往史',WJJGXSMC ,NULL)) AS GMC既往史
FROM TABLE
GROUP BY ID

Create view 视图名称
as
sql 语句