Atlassian Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
4Questions
1Company
4 Questions 1 Company
Showing 4 results
Atlassian
Medium
Data ScientistIdentify Top-3 Users by Recent Total Spend
Users +----+-------+-------------+ | id | name | joined_date | +----+-------+-------------+ | 1 | Alice | 2023-01-02 | | 2 | Bob | 2023-02-14 |...
Data Manipulation (SQL/Python)
82
0
Aug 4, 2025
Atlassian
Medium
Data ScientistLabel game performance by margin
Given a games DataFrame (or R data.frame) with columns: team_id, opponent_team_id, team_score, opponent_team_score, write code to: (1) Define a functi...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Atlassian
Medium
Data ScientistRank each team’s top 3 scores in 2024
Using the same schema, compute each team’s top 3 highest-scoring games for season_year = 2024, treating each game from BOTH teams’ perspectives (i.e.,...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Atlassian
Medium
Data ScientistFind 2023 NCAA championship winner
You are given two tables. Schema: team(team_id INT PRIMARY KEY, team_name TEXT); game(game_id INT PRIMARY KEY, team_id INT, opponent_team_id INT, date...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025