SQL：2 题\nPython/R： 2题\nSQL:\nSQL:\nNCAA tables:\nGame table: team_id, opponent_team_id, date, season_year, team_score, opponent_team_score\nTeam table: team_id, team_name\n1. Please find the team name that won the 2023 “CHAMPIONSHIP” in the NCAA game?\n2. Please find for each team the top 3 games and scores in the 2024 season and return the following columns:\n 1. Team name. Waral dи,\n 2. Opponent team name \n 3. Team score \n 4. Score rank \n. Χ\nPython/R:\n\n3. 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 - opponent_score), using the following rules:\n- 'Blowout Win' if the margin is greater than or equal to 20\n- 'Close Win' if the margin is between 1 and 19. 1point 3 acres\n- 'Tie' if the margin is 0\n- 'Close Loss' if the margin is between -1 and -19\n- 'Blowout Loss' if the margin is less than or equal to -20\nApply this function to each row in the games DataFrame to create a new column called 'performance_label'.\n\n4. Write some code to train a data set and predict the test set data based on 6 features (continuous) and the outcome is binary (0,1)\nTraining data: x<- read.csv()\nTesting data: x_test<-read.csv(). 1point 3acres\nPredictors: x_train <- x[2:6]\nX_test <- x_test[2:6]. Χ\nOutcomes: y_train <- x[1]\ny_test <- x_test[1]\n\n最后一题应该是考察用Logistic regression。要看在modeling前是否检查data，看correlation，根据correlation看base model，然后还要用到feature selection，Lasson或者Ridge\n\nBehavioral:\n\n1. Why do you want to join Atlassian?\n2. Tell me a time when you need to give constructive feedback. Follow up: how did the other person react and what did you do? What did you learn from this experience?\n3. How do you balance competing priorities? What did you learn from your experience? What are your trade-offs?\n4. Tell me a time when you went above and beyond for customers to drive a change but your efforts failed? What did you learn?\n5. What is the most effective team you have been on? What makes them effective and what qualities do they have?