Mysql笔试2021年12月_3真题|持续分享|点个关注

  学员出去2021-12-29面试遇到的真题，分享给大家

第一题：

SELECT  b.NAME AS c_Name,  NAME,  Sex,  Score FROM  student a  LEFT JOIN class b ON a.c_Id＝b.Id WHERE  a.Score = ( SELECT max( Score ) FROM student );

第二题：

SELECT  b.NAME AS c_Name,  count( 1 ) AS Rs,  avg( Score ) AS Score FROM  student a  INNER JOIN class b ON a.c_Id＝b.Id GROUP BY  b.NAME ORDER BY  Score DESC;

第三题：​​​​​​​

SELECT  b.NAME AS c_Name,  NAME,  Sex,  Score FROM  student a  LEFT JOIN class b ON a.c_Id＝b.Id WHERE  b.Id IS NULL;