1. Home
  2. Discover
  3. Technology
  4. Data Interview Qs

Highest performing students by college program

InterviewQs

Highest performing students by college program
SQL Database Querying Subquery Case Statement

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

Hi, 

Suppose you're given the tables below, containing information about various college programs, as well as students currently enrolled in the listed universities. Note that 'college_name_program_id' is a unique identifier for the college/program combination.

Table: college_info

college_name_program_id college_name college_program
00001 University A Engineering
00002 University A Business
00003 University A Mathematics
00004 University B Engineering
00005 University B Business
00006 University B Mathematics
00007 University C Engineering
00008 University C Business
00009 University C Mathematics

Table: student_apps

student_id college_name_program_id gpa
31331 00001 2.8
34583 00001 3.1
23455 00002 3.5
23454 00005 3.8
22337 00007 2.5
00112 00009 3.3
12332 00004 3.4
99123 00003 2.1
87903 00002 4
23547 00002 3.7
66543 00003 3.6
34554 00001 3.1

Using the tables above, write a SQL query to return the number of students in each department/program (agnostic of university) that have a GPA of at least 3.3.

You can view/query this table in an interactive SQL fiddle here.


 

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

new Case studies interactive SQL fiddle various college programs University A Engineering University A Business University B Engineering University B Business University C Engineering University C Business Highest performing students

Older messages

Multicollinearity in linear regression

Friday, October 28, 2022

Statistics, Regression, Multicollinearity, PCA, InterviewQs Multicollinearity in linear regression Statistics Regression Multicollinearity PCA Forward this email to a friend or colleague and challenge

First recurring character

Wednesday, October 26, 2022

Python, Algorithms, Sets, InterviewQs First recurring character Python Algorithms Sets Forward this email to a friend or colleague and challenge them to solve it. Hi, Write a function that returns the

Staffing for hospital births

Monday, October 24, 2022

Statistics, Probability Theory, Poisson Distribution, InterviewQs Staffing for hospital births Statistics Probability Theory Poisson Distribution Forward this email to a friend or colleague and

Calculating cost per square foot

Friday, October 21, 2022

SQL, Database Querying, Subquery, Join, InterviewQs Calculating cost per square foot SQL Database Querying Subquery Join Forward this email to a friend or colleague and challenge them to solve it. Hi,

Simulating wealth over time while playing a biased coin toss game

Wednesday, October 19, 2022

Python, Simulation, Statistics, Data Visualization, Kelly Criterion, InterviewQs Simulating wealth over time while playing a biased coin toss game Python Simulation Statistics Data Visualization Kelly

You Might Also Like

Data Science Weekly - Issue 543

Friday, April 19, 2024

Curated news, articles and jobs related to Data Science, AI, & Machine Learning ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏

A deal made in cloud security heaven

Thursday, April 18, 2024

Meta's Llama 3 goes public and hackers hold World-Check data for ransom View this email online in your browser By Christine Hall Thursday, April 18, 2024 Welcome to TechCrunch PM! I'm glad you

💎 Issue 413 - RubyJS-Vite

Thursday, April 18, 2024

This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 413 Release Date Apr 18, 2024 Your weekly report of the most popular Ruby news, articles and

💻 Issue 406 - Swift for C++ Practitioners, Part 1

Thursday, April 18, 2024

This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 406 Release Date Apr 18, 2024 Your weekly report of the most popular .NET news, articles and projects

💻 Issue 413 - How to implement HLS Video Streaming in a React App

Thursday, April 18, 2024

This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 413 Release Date Apr 18, 2024 Your weekly report of the most popular Node.js news, articles and

📱 Issue 407 - Textual Healing: iOS Text Editing Minutiae

Thursday, April 18, 2024

This week's Awesome iOS Weekly Read this email on the Web The Awesome iOS Weekly Issue » 407 Release Date Apr 18, 2024 Your weekly report of the most popular iOS news, articles and projects Popular

💻 Issue 413 - Interview with Senior JavaScript Developer 2024 [video]

Thursday, April 18, 2024

This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 413 Release Date Apr 18, 2024 Your weekly report of the most popular JavaScript news, articles

💻 Issue 331 - 30+ app ideas with complete source code

Thursday, April 18, 2024

This week's Awesome React Weekly Read this email on the Web The Awesome React Weekly Issue » 331 Release Date Apr 18, 2024 Your weekly report of the most popular React news, articles and projects

💻 Issue 408 - Curl: Hyper, is it worth it?

Thursday, April 18, 2024

This week's Awesome Rust Weekly Read this email on the Web The Awesome Rust Weekly Issue » 408 Release Date Apr 18, 2024 Your weekly report of the most popular Rust news, articles and projects

📱 Issue 410 - Swift for C++ Practitioners, Part 1

Thursday, April 18, 2024

This week's Awesome Swift Weekly Read this email on the Web The Awesome Swift Weekly Issue » 410 Release Date Apr 18, 2024 Your weekly report of the most popular Swift news, articles and projects