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

Loading problem...

Preparing your editor. You can read the problem while it loads.

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