Campus Excellence Challenge Winner

Easy

An academic benchmarking program compares two universities using exam quality outcomes. Table: Atlantic student_id: unique student identifier score: exam score in the range [0, 100] Table: Pacific student_id: unique student identifier score: exam score in the range [0, 100] Competition rule: An excellent student is one whose score is at least 90. The university with more excellent students wins. If both universities have the same excellent-student count, the result is a draw. Both tables always contain the same number of students. Task: Return one row with one column winner. Required winner values: "Atlantic Institute" if Atlantic wins "Pacific Institute" if Pacific wins "No Winner" if there is a draw Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

Atlantic:
| student_id | score |
|------------|-------|
| 1          | 90    |
| 2          | 87    |

Pacific:
| student_id | score |
|------------|-------|
| 11         | 89    |
| 12         | 88    |

Output

[{"winner":"Atlantic Institute"}]

Explanation

Atlantic has 1 excellent student (score >= 90), while Pacific has 0.

Example 2

Input

Atlantic:
| student_id | score |
|------------|-------|
| 1          | 89    |
| 2          | 88    |
| 3          | 91    |

Pacific:
| student_id | score |
|------------|-------|
| 11         | 90    |
| 12         | 94    |
| 13         | 89    |

Output

[{"winner":"Pacific Institute"}]

Explanation

Atlantic has 1 excellent student and Pacific has 2, so Pacific wins.

Example 3

Input

Atlantic:
| student_id | score |
|------------|-------|
| 1          | 90    |
| 2          | 80    |
| 3          | 95    |

Pacific:
| student_id | score |
|------------|-------|
| 11         | 70    |
| 12         | 90    |
| 13         | 97    |

Output

[{"winner":"No Winner"}]

Explanation

Each university has exactly 2 excellent students.

Constraints

0 <= number of rows in Atlantic <= 1200
0 <= number of rows in Pacific <= 1200
Atlantic and Pacific contain the same number of rows
student_id is unique within each table
0 <= score <= 100
Return exactly one row
Return exactly one output column named winner
winner must be one of: Atlantic Institute, Pacific Institute, No Winner
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with one column winner

Atlantic: | student_id | score | |------------|-------| | 1 | 90 | | 2 | 87 | Pacific: | student_id | score | |------------|-------| | 11 | 89 | | 12 | 88 |

Atlantic: | student_id | score | |------------|-------| | 1 | 89 | | 2 | 88 | | 3 | 91 | Pacific: | student_id | score | |------------|-------| | 11 | 90 | | 12 | 94 | | 13 | 89 |

Atlantic: | student_id | score | |------------|-------| | 1 | 90 | | 2 | 80 | | 3 | 95 | Pacific: | student_id | score | |------------|-------| | 11 | 70 | | 12 | 90 | | 13 | 97 |