题目链接：点击打开链接
题目大意：略。
解题思路：略。
AC 代码
WITH t1 AS(SELECT COUNT(*) s1 FROM NewYork WHERE score >= 90), t2 AS(SELECT COUNT(*) s2 FROM California WHERE score >= 90) SELECT CASE WHEN s1 > s2 THEN 'New York University' WHEN s1 < s2 THEN 'California University' ELSE 'No Winner' END winner FROM t1, t2
