请大家帮忙写几条SQL语句，谢谢。

[qq_29448025]

[imcmuc]

SELECT T1.SL, T2.NAME, T2.SCORE
  FROM (SELECT COUNT(1) SL FROM SC) T1,
       (SELECT NAME,
               SCORE,
               ROW_NUMBER() OVER(PARTITION BY NULL ORDER BY SCORE DESC) RN
          FROM SC
         WHERE COURSE = '数学') T2
 WHERE T2.RN = 1;

SELECT NAME
  FROM SC T1
 WHERE COURSE = '语文'
   AND SCORE > (SELECT MAX(SCORE)
                  FROM SC T2
                 WHERE COURSE = '数学'
                   AND T1.NAME = T2.NAME)

SELECT NAME FROM SC WHERE COURSE = '语文'
INTERSECT
SELECT NAME FROM SC WHERE COURSE = '数学'

[猜我是几娃]

前提：score的类型为number ，如果为char，需要 to_number 1、select (count(1) from tablename) 记录条数, (select t.name from tablename t where t.score=(select max(score) from tablename where course='数学')) 数学最好的人 from dual; 2、select a.name from (select name,score from tablename where course='语文') a inner join (select name,score from tablename where course='数学') b on a.name=b.name where a.score > b.score 3、select a.name from (select name,score from tablename where course='语文') a inner join (select name,score from tablename where course='数学') b on a.name=b.name