Checking interview scores for accepted candidates

InterviewQs

Checking interview scores for accepted candidates

SQL Database Querying

Forward this email to a friend or colleague and challenge them to solve it.

Hi, 

Suppose your team is looking to see if there's a relationship between interview scores and on the job performance for folks who were hired at your company.

You're given the below tables, detailing candidate offer statuses ('Accepted', 'Declined', 'Rejected') as well as associated interview scores. Using these tables, write a SQL query to return the interview scores for candidates who accepted an offer.


Table: candidateStatus

candidate_name candidate_status
john_smith Accepted
sarah_daniels Declined
tim_cook Accepted
lisa_perelli Rejected
jenny_west Rejected
karl_tran Declined
tammy_turner Declined

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).

candidate_name interview_score
john_smith 4
sarah_daniels 5
tim_cook 4
lisa_perelli 2
jenny_west 2
karl_tran 4
tammy_turner 3

For simplicity, these tables are small, but you can assume in practicality the tables would be way too large to export or visually search through.

You can view/query the data in an interactive SQL fiddle here.


 

You’ve accumulated 337 questions since joining our email list. Create a premium account to access detailed solutions to each problem (including this one) + our new Case studies.


Was this email forwarded to you? You can join our list here to receive questions

How did you like today's question?

15411 Boischatel, Montreal, QC, H9H1Y7, Canada
Don't want to get these emails anymore? We'll forgive you if you unsubscribe

Key phrases

Older messages

Correlation between aces and points won in tennis

Wednesday, August 24, 2022

Data Analysis, Python, Pandas, External Dataset, Data Manipulation, Data Visualization, Statistics, Pearson's R, Chi-squared Test, InterviewQs Correlation between aces and points won in tennis Data

Estimate Pi using Monte Carlo methods

Monday, August 22, 2022

Python, Algorithms, Loops, InterviewQs Estimate Pi using Monte Carlo methods Python Algorithms Loops Forward this email to a friend or colleague and challenge them to solve it. Hi, We can define the

Simulate a Markov chain modeling the evolution of a population

Friday, August 19, 2022

Python, Statistics, Markov Chain, Modeling, Vectorization, Parallelization, InterviewQs Simulate a Markov chain modeling the evolution of a population Python Statistics Markov Chain Modeling

Total value of trades

Wednesday, August 17, 2022

SQL, Database Querying, Window Function, Subquery, InterviewQs Total value of trades SQL Database Querying Window Function Subquery Forward this email to a friend or colleague and challenge them to

Analyzing a locker storage system

Monday, August 15, 2022

Data Analysis, Python, Pandas, External Dataset, Data Manipulation, Data Visualization, Statistics, Probability Mass Function, InterviewQs Analyzing a locker storage system Data Analysis Python Pandas

Kotlin Weekly #340

Sunday, February 5, 2023

ISSUE #340 5th of February 2023 Announcements We Are Improving Library Authors' Experience! Are you a Kotlin librarian? The JetBrains team explains in this post some of the things they are doing to

Open Assistant – project meant to give everyone access to a great chat based LLM — Update on Samsung SSD Reliability — and Universal Summarizer

Saturday, February 4, 2023

Issue #1033 — Top 20 stories of February 05, 2023 Issue #1033 — February 05, 2023 You receive this email because you are subscribed to Hacker News Digest. You can open it in the browser if you prefer.

Daily Coding Problem: Problem #1013 [Medium]

Saturday, February 4, 2023

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Yahoo. Write a function that returns the bitwise AND of all integers between M and N ,

How to Use a USB Flash Drive With an Android Phone or Tablet

Saturday, February 4, 2023

Did You Know?: The theme song for the popular PBS show The Magic School Bus was performed by none other than rock-and-roll great Little Richard. Read in Browser Logo for How-To Geek February 4, 2023

Ranked | Top Online Music Services in the U.S. by Monthly Users 🎼

Saturday, February 4, 2023

This graphic shows the percentage of Americans that are monthly music listeners for each service. Which is most popular? View Online | Subscribe FEATURED STORY The Top Online Music Services in the US

Week in Review - Netflix crackdown, monetizing ChatGPT and bypassing FB’s 2FA

Saturday, February 4, 2023

TechCrunch Newsletter TechCrunch logo Week in Review logo By Henry Pickavet Saturday, February 04, 2023 Happy weekend, folks, and welcome back to the TechCrunch Week in Review. Henry here, standing in

Noonification: A Brief History of Open Source

Saturday, February 4, 2023

Top Tech Content sent at Noon! Get hands-on learning from ML experts on Coursera How are you, @hacker? 🪐 What's happening in tech this week: The Noonification by HackerNoon has got you covered with

Startups Weekly - 2023 is the year of the bottom line 

Saturday, February 4, 2023

TechCrunch Newsletter TechCrunch logo Startups Weekly logo By Natasha Mascarenhas Saturday, February 04, 2023 Welcome to Startups Weekly, a nuanced take on this week's startup news and trends by

One Song, Many Writers 🎸

Saturday, February 4, 2023

Why modern songs have super-sized writing credits. Here's a version for your browser. Hunting for the end of the long tail • February 04, 2023 Hey all, Ernie here with a piece from Chris Dalla Riva

🐍 New Python tutorials on Real Python

Saturday, February 4, 2023

Hey there, There's always something going on over at realpython.com as far as Python tutorials go. Here's what you may have missed this past week: How to Iterate Over Rows in pandas, and Why