Atlassian Technical + BQ

SQL：2 题
Python/R： 2题
SQL:
SQL:
NCAA tables:
Game table: team_id, opponent_team_id, date, season_year, team_score, opponent_team_score
Team table: team_id, team_name
1. Please find the team name that won the 2023 “CHAMPIONSHIP” in the NCAA game?
2. Please find for each team the top 3 games and scores in the 2024 season and return the following columns:
    1. Team name
    2. Opponent team name 
    3. Team score 
    4. Score rank 

Python/R:
3. Write a function that returns a performance label for each game for the team_id, based on the margin of victory or defeat (team_score - o

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

? What are your trade-offs?
4. Tell me a time when you went above and beyond for customers to drive a change but your efforts failed? What did you learn?
5. What is the most effective team you have been on? What makes them effective and what qualities do they have?

面bq前可以认真看看他们家的value，以customer为中心，合作友好等等！

求米！我现在还是不能看面经 积分太低了

请问面的是什么岗呀？

同问，请问楼主，这是什么岗？

求米。。好难 就差十几米

感谢分享。请问面完最后一轮之后多久收到拒信？

感谢楼主分享，求稳面的是什么岗位？谢谢！