회사 L팀 구조 및 역할A와 본인은 비슷한 팀에서 함께 채용 중이지만, A는 더 엔지니어링 중심이고, 본인은 SQL 중심의 데이터팀을 담당하고 있음.A 팀의 주요 이해관계자들은 엔지니어, 데이터 사이언티스트, 프로덕트 팀처럼 기술적인 사람들.본인 팀의 주요 이해관계자들은 마케팅, 재무, 회계, 법무, 운영 등 비기술적인 직군.역할의 기술적 요구 사항SQL이 메인.단순히 SQL 코딩뿐 아니라, 데이터가 시스템 간 어떻게 흐르고 변환되는지를 이해하고, 이해관계자들에게 쉽게 설명할 수 있는 능력이 중요함.‘ELI5 (Explain Like I’m 5)’ 능력이 필요: 비기술자에게 데이터 파이프라인 구조를 쉽게 설명하는 스킬.우리가 찾는 사람기술적 베이스라인은 있음 (SQL 능력 확인됨).더 중요하게 보는 건:..

회사 L리크루어터와의 면접, 매니저와의 면접, 기술 면접, 그 후 타부서와의 면접으로 진행됐습니다. 밑의 질문들은 타부서와의 면접에서 받은 질문입니다.Q: What other teams do you work with cross-functionally?Sample Answer (STAR):S: In a recent project focused on improving internal reporting tools,T: I was responsible for designing a dashboard that summarized key operational metrics.A: To do this, I collaborated closely with business analysts, the IT department, ..

You did such a great job helping Julia with her last coding contest challenge that she wants you to work on this one, too! The total score of a hacker is the sum of their maximum scores for all of the challenges. Write a query to print the hacker_id, name, and total score of the hackers ordered by the descending score. If more than one hacker achieved the same total score, then sort the result b..

Julia asked her students to create some coding challenges. Write a query to print the hacker_id, name, and the total number of challenges created by each student. Sort your results by the total number of challenges in descending order. If more than one student created the same number of challenges, then sort the result by hacker_id. If more than one student created the same number of challenges ..

Harry Potter and his friends are at Ollivander's with Ron, finally replacing Charlie's old broken wand. Hermione decides the best way to choose is by determining the minimum number of gold galleons needed to buy each non-evil wand of high power and age. Write a query to print the id, age, coins_needed, and power of the wands that Ron's interested in, sorted in order of descending power. If more ..

Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respective hacker_id and name of hackers who achieved full scores for more than one challenge. Order your output in descending order by the total number of challenges in which the hacker earned a full score. If more than one hacker received full scores in same number of..