hive试题求解答，想要速度解答

hive试题求解答，希望能在1个小时内解答一下，比较急，谢谢

我在写，表也要自己创建吗

题目很简单，但是过程比较繁琐

1、

CREATE TABLE sc (
  sno string,
  cno string,
  grade int
)
LOCATION '/tust/sc';

LOAD DATA INPATH '/tust/sc_data.txt' INTO TABLE sc;

2、

SELECT sno
FROM sc
WHERE cno = '1' AND grade > (SELECT grade FROM sc WHERE cno = '2' AND sno = sc.sno)

3、

SELECT DISTINCT sno
FROM sc
WHERE cno IN ('1', '2')

4、

SELECT cno, AVG(grade), MAX(grade), MIN(grade), SUM(grade), COUNT(sno)
FROM sc
GROUP BY cno

5、

SELECT sno, grade
FROM sc
WHERE cno = '1' AND grade >= 60

望采纳