Data Interview Qs - Data Interview Questions: Problem #69
Top candidates by college
SQL Database Querying Rank Function Window Function
Suppose your team interviews undergraduate candidates across many different colleges. You are looking to check which candidates scored the highest from each college.
Given the below tables, write a SQL query (using a window function) to show which candidates scored the highest from each college.
Table: candidateColleges
| college_id | candidate_name |
|---|---|
| 123456 | john_smith |
| 123456 | sarah_daniels |
| 123457 | tim_cook |
| 123457 | lisa_perelli |
| 123457 | jenny_west |
| 123457 | karl_tran |
| 123457 | tammy_turner |
Table: candidateInterviews
Each row represents a unique interview/candidate as well as the candidate's score (an integer from 1-5, with 5 representing the highest possible score).
| interview_id | candidate_name | interview_score |
|---|---|---|
| 12 | john_smith | 4 |
| 22 | sarah_daniels | 3 |
| 23 | tim_cook | 3 |
| 25 | lisa_perelli | 5 |
| 26 | jenny_west | 2 |
| 27 | karl_tran | 2 |
| 28 | tammy_turner | 4 |
Want the solutions? Upgrade to premium to access detailed solutions to each problem (including this one).
Was this email forwarded to you? You can join our list here to receive questions
Unsubscribe
Older messages
Data Interview Questions: Problem #68
Friday, September 11, 2020
Data Interview Qs Employee Attrition Data Analysis Python Pandas Data Manipulation Correlation Pearson's R External Dataset The following dataset contains the following fields that describe
Data Interview Questions: Problem #67
Wednesday, September 9, 2020
Data Interview Qs Naive Bayes Statistics Naive Bayes' Theorem What is Naive Bayes' theorem, and why is it considered 'naive'? Why is it often used in practical applications rather than
Data Interview Questions: Problem #66
Monday, September 7, 2020
Data Interview Qs Alternative array sorting Python Data Structures Arrays Given an array of integers, print the array in alternating min/max order. The first element should be the first maximum, second
Data Interview Questions: Problem #65
Friday, September 4, 2020
Data Interview Qs Breaking down customer transactions in SQL SQL Database Querying Window Function Given the following table containing customer transaction data: Table name: orders order_id channel
Data Interview Questions: Problem #64
Friday, September 4, 2020
Data Interview Qs Application feedback Data Analysis Python Pandas Data Manipulation Your team at Apple released a new feature that collects feedback when an app launches. As part of the Alpha Launch
You Might Also Like
Stripe changes its … stripes
Wednesday, April 24, 2024
TikTok on the president's docket and Nvidia acquires Run:ai View this email online in your browser By Christine Hall Wednesday, April 24, 2024 Good afternoon, and welcome to TechCrunch PM! Today
💪 You Can Use Copilot AI as a Personal Trainer — Why Your Laptop Needs a Docking Station
Wednesday, April 24, 2024
Also: Here's How to Make Your Apple ID Recoverable, and More! How-To Geek Logo April 24, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to
JSK Daily for Apr 24, 2024
Wednesday, April 24, 2024
JSK Daily for Apr 24, 2024 View this email in your browser A community curated daily e-mail of JavaScript news JSK Weekly - 24th April, 2024 React 19 has introduced many great functionalities and
Daily Coding Problem: Problem #1422 [Hard]
Wednesday, April 24, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Airbnb. Given a list of integers, write a function that returns the largest sum of non-
Charted | Artificial Intelligence Patents, by Country 🤖
Wednesday, April 24, 2024
This visualization shows which countries have been granted the most AI patents each year, from 2012 to 2022. View Online | Subscribe Presented by: New on VC+: Our Visual Briefing on the IMF's World
Save your seat: 1Password’s 2024 Security report insights webinar
Wednesday, April 24, 2024
Join us April 25th. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Top Tech Deals 📱 LG Flex TV, Google Pixel 7, DJI Mini 3, and More
Wednesday, April 24, 2024
Get yourself a discounted DJI drone, save on the Pixel 7, or score some PC and phone accessories. How-To Geek Logo April 24, 2024 Top Tech Deals: LG Flex TV, Google Pixel 7, DJI Mini 3, and More Find
The Protest Song Wakes Up 🎙️
Wednesday, April 24, 2024
Is this song the future of musical protest? Here's a version for your browser. Hunting for the end of the long tail • April 24, 2024 The Protest Song Wakes Up A buzzy protest song about the
JSK Weekly - 24th April, 2024
Wednesday, April 24, 2024
React 19 has introduced many great functionalities and features, among which the useOptimistic hook stands out. The useOptimistic hook offers a seamless way to manage UI states during asynchronous
The clock’s ticking for TikTok
Wednesday, April 24, 2024
The US Senate has passed a bill that would ban TikTok if its US business is not divested by Bytedance View this email online in your browser By Alex Wilhelm Wednesday, April 24, 2024 Good morning, and