Data Interview Qs - College interview results

InterviewQs

College interview results

SQL Database Querying

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

Hi, 

Suppose your team interviews undergraduate candidates across many different colleges. You are provided the following tables, and asked to determine which colleges have the highest pass through rate (number of candidates offered a position / number of candidates interviewed) as well as the colleges with the highest total # of offers. This will help your team prioritize future campus visits and help spread interview load. Write a SQL query to return these two results.


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, and flags whether or not we extended an offer as well as whether or not the candidate accepted. 1 means the offer was extended, 0 means it was not.

interview_id candidate_name flag_offer_extended flag_offer_accepted
12 john_smith 1 1
22 sarah_daniels 1 0
23 tim_cook 0 0
25 lisa_perelli 0 0
26 jenny_west 1 0
27 karl_tran 1 1
28 tammy_turner 1 1


 

You’ve accumulated 213 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

Older messages

Counting capital letters

Wednesday, November 10, 2021

Python, String Manipulation, InterviewQs Counting capital letters Python String Manipulation Forward this email to a friend or colleague and challenge them to solve it. Hi, Using Python, write code

School mascots

Monday, November 8, 2021

Statistics, Probability Theory, Bayes' Theorem, Conditional Probability, InterviewQs School mascots Statistics Probability Theory Bayes' Theorem Conditional Probability Forward this email to a

Smallest, unrepresented integer

Friday, November 5, 2021

Python, Data Structures, Arrays, InterviewQs Smallest, unrepresented integer Python Data Structures Arrays Forward this email to a friend or colleague and challenge them to solve it. Hi, Given a sorted

eCommerce Margins

Wednesday, November 3, 2021

SQL, Database Querying, Rank Function, Window Function, InterviewQs eCommerce Margins SQL Database Querying Rank Function Window Function Forward this email to a friend or colleague and challenge them

K-means cluster plot

Monday, November 1, 2021

Data Analysis, Python, Pandas, Data Manipulation, Data Visualization, K-means, Clustering, InterviewQs K-means cluster plot Data Analysis Python Pandas Data Manipulation Data Visualization K-means

You Might Also Like

PHPWeekly March 28th 2024

Thursday, March 28, 2024

Curated news all about PHP. Here's the latest edition Is this email not displaying correctly? View it in your browser. PHP Weekly 28th March 2024 Hi everyone, The long weekend is coming up, and if

Hulu officially joins Disney+

Thursday, March 28, 2024

The Morning After It's Thursday, March 28, 2024. A month after taking full ownership of Hulu last November, Disney started beta testing integration with Disney+. Today, Hulu on Disney+ is

Post from Syncfusion Blogs on 03/28/2024

Thursday, March 28, 2024

New blogs from Syncfusion Chart of the Week: Creating a .NET MAUI Column Chart to Visualize the Corporate Investment in AI By Saiyath Ali Fathima M Let's visualize the data on corporates'

New ZenHammer Attack Bypasses Rowhammer Defenses on AMD CPUs

Thursday, March 28, 2024

THN Daily Updates Newsletter cover Webinar: From Blind Spots to Bulletproof: Secure Your Apps with Shared Responsibility From oversight to overwatch: Discover the art of bulletproof app security with

Top Tech 🏆 Synology BeeStation NAS Review — Testing Anker's EverFrost Dual-Zone Powered Cooler

Thursday, March 28, 2024

Also: We Review the Arlo Essential Indoor Cam 2nd Gen, and More! How-To Geek Logo March 28, 2024 📩 Get the hottest deals, how-to's, breaking news, and more delivered directly to your inbox by

Last Chance

Thursday, March 28, 2024

Hello there, I wanted to follow up on our last email to let you know that our introductory iPhone Life Insider offer will expire tomorrow! Currently, a subscription to iPhone Life Insider costs $9.99/

Edge 381: Google DeepMind's PrompBreeder Self-Improves Prompts

Thursday, March 28, 2024

The method combines chain of thoughts, plan and solve and evolutionary algorithms in a single mthod. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏

Anthropic beats GPT-4 🤖, Pixel 9 leaks 📱, the fight for AI talent 👨‍💻

Thursday, March 28, 2024

Anthropic's Claude 3 Opus has surpassed OpenAI's GPT-4 for the first time on Chatbot Arena Sign Up|Advertise|View Online TLDR Together With Dollar Flight Club TLDR 2024-03-28 Exclusive offer:

From Request to Response: How APIs Work – Beginners Guide

Thursday, March 28, 2024

In the vast expanse of the digital ecosystem, APIs (Application Programming Interfaces) act as critical conduits, facilitating seamless conversations between different software platforms. From clicking

Elastic 8.13 is here: Amazon Bedrock in the AI Assistant for Observability

Thursday, March 28, 2024

Learn about Amazon Bedrock support within the Elastic AI Assistant for Observability ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ elastic | Search. Observe. Protect