--制作交叉表:使用外连接SELECT c0.name,CASEWHEN c1.name ISNOTNULLTHEN'O'ELSE'X'ENDAS'SQL入门',CASEWHEN c2.name ISNOTNULLTHEN'O'ELSE'X'ENDAS'UNIX基础',CASEWHEN c3.name isNOTNULLTHEN'O'ELSE'X'ENDAS'Java中级'FROM(SELECTDISTINCT name FROM Courses) C0
LEFTOUTERJOIN(SELECT name FROM Courses WHERE course='SQL入门') C1
ON c0.name = c1.name
LEFTOUTERJOIN(SELECT name FROM Courses WHERE course='UNIX基础') C2
ON c0.name = c2.name
LEFTOUTERJOIN(</