00:00:00

Description

Editorial

Campus Excellence Challenge Winner

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Pacific =

[{"student_id":11,"score":89},{"student_id":12,"score":88}]

Atlantic =

[{"student_id":1,"score":90},{"student_id":2,"score":87}]

Loading problem...

101

00:00:00

Description

Editorial

Campus Excellence Challenge Winner

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Pacific =

[{"student_id":11,"score":89},{"student_id":12,"score":88}]

Atlantic =

[{"student_id":1,"score":90},{"student_id":2,"score":87}]

Campus Excellence Challenge Winner

Hints

Campus Excellence Challenge Winner

Hints