谁能写出这样的 SQL 语句?
原表为:
---------------------------------------------------
儿童 | 疫苗 | 预种日期 | 接种日期 |
---------------------------------------------------
李小颖 | 卡介苗 | 1999-02-06 | 2003-03-08
---------------------------------------------------
李小颖 | 糖丸 | 2002-03-21 | <NULL>
---------------------------------------------------
李小颖 | 乙肝 | 2000-12-23 | 2009-01-01
---------------------------------------------------
宁愿 | 卡介苗 | 2003-09-12 | 2569-05-09
---------------------------------------------------
宁愿 | 糖丸 | <NULL> | 1899-02-09
---------------------------------------------------
宁愿 | 乙肝 | 2003-05-09 | 1997-12-31
---------------------------------------------------
武绍阳 | 卡介苗 | 1968-03-31 | 2000-09-09
---------------------------------------------------
武绍阳 | 糖丸 | 1981-03-31 | 9999-05-09
---------------------------------------------------
武绍阳 | 乙肝 | 2000-02-09 | 1996-05-08
---------------------------------------------------
写 SQL 语句实现输出为:
-------------------------------------------------------
儿童 |预种实种| 卡介苗 | 糖丸 | 乙肝
-------------------------------------------------------
李小颖| 预种 | 1999-02-06 | 2002-03-21 | 2000-12-23
-------------------------------------------------------
李小颖| 实种 | 2003-03-08 | <NULL> | 2009-01-01
-------------------------------------------------------
宁愿 | 预种 | 2003-09-12 | <NULL> | 2003-05-09
-------------------------------------------------------
宁愿 | 实种 | 2569-05-09 | 1899-02-09 | 1997-12-31
-------------------------------------------------------
武绍阳| 预种 | 1968-03-31 | 1981-03-31 | 2000-02-09
-------------------------------------------------------
武绍阳| 实种 | 2000-09-09 | 9999-05-09 | 1996-05-08
-------------------------------------------------------