with excellent_std_cntsas (select (selectcount(student_id)from NewYorkwhere score>=90)as ny,

(selectcount(student_id)from Californiawhere score>=90)as ca)

select (case

whenE.ny>E.ca then'New York University'

whenE.ny<E.ca then'California University'

else'No Winner'

end

)as winner

from excellent_std_cntsas E

| 2990|[Loan Types](https://leetcode.com/problems/loan-types/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2990.sql)|| Easy|

| 2205|[The Number of Users That Are Eligible for Discount](https://leetcode.com/problems/the-number-of-users-that-are-eligible-for-discount/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2205.sql)|| Easy|

| 2082|[The Number of Rich Customers](https://leetcode.com/problems/the-number-of-rich-customers/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2082.sql)|| Easy|

| 2072|[The Winner University](https://leetcode.com/problems/the-winner-university/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2072.sql)|| Easy|

| 1789|[Primary Department for Each Employee](https://leetcode.com/problems/primary-department-for-each-employee/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1789.sql)|| Easy|

| 1757|[Recyclable and Low Fat Products](https://leetcode.com/problems/recyclable-and-low-fat-products/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1757.sql)|| Easy|

| 1741|[Find Total Time Spent by Each Employee](https://leetcode.com/problems/find-total-time-spent-by-each-employee/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1741.sql)|| Easy|