Data Interview Qs - Employees who are managers

InterviewQs

Employees who are managers

SQL Database Querying

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

Hi, 

You're trying to understand how many managers you have per employee at Company XYZ. On your search to understand, you are given two tables: (1) managers and (2) employees. Each table has 1 column named id. Given this dataset, can you use SQL to find the employees that are also managers?

Hint: given the table names as well as the single column name you should be able to write a full SQL query.



 

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

Create a model to predict bicycle ridership

Monday, October 4, 2021

Python, Pandas, Data Analysis, External Dataset, Linear Regression, Data Visualization, InterviewQs Create a model to predict bicycle ridership Python Pandas Data Analysis External Dataset Linear

Probability of choosing a diamond

Friday, October 1, 2021

Statistics, Probability Theory, Conditional Probability, InterviewQs Probability of choosing a diamond Statistics Probability Theory Conditional Probability Forward this email to a friend or colleague

Average lifetime value of a customer

Wednesday, September 29, 2021

Python, Product Metrics, Pandas, Data Analysis, External Dataset, InterviewQs Average lifetime value of a customer Python Product Metrics Pandas Data Analysis External Dataset Forward this email to a

Office space capacity

Monday, September 27, 2021

SQL, Database Querying, InterviewQs Office space capacity SQL Database Querying Forward this email to a friend or colleague and challenge them to solve it. Hi, You are given a table of office sites

Customer recency

Friday, September 24, 2021

Data Analysis, Python, Pandas, Data Manipulation, External Dataset, InterviewQs Customer recency Data Analysis Python Pandas Data Manipulation External Dataset Forward this email to a friend or

You Might Also Like

Tesla layoffs gutted some departments

Tuesday, April 16, 2024

Tesla departments hit hard View this email online in your browser By Christine Hall Tuesday, April 16, 2024 Good afternoon, and welcome back to TechCrunch PM. Today I bring you updates on what's

🤖 Google Play Pass Is Actually a Great Deal — Samsung's Ecosystem Is as Good as Apple's

Tuesday, April 16, 2024

Also: We Review a Robot Window Cleaner, and More! How-To Geek Logo April 16, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your inbox by

JSK Daily for Apr 16, 2024

Tuesday, April 16, 2024

JSK Daily for Apr 16, 2024 View this email in your browser A community curated daily e-mail of JavaScript news React useState Vs. Context API: When to Use Them React has improved its state management

Pydantic, Web Security, State of Python, and More

Tuesday, April 16, 2024

Pydantic: Simplifying Data Validation in Python #625 – APRIL 16, 2024 VIEW IN BROWSER The PyCoder's Weekly Logo Pydantic: Simplifying Data Validation in Python Discover the power of Pydantic,

Save big - online product conference on May 2nd

Tuesday, April 16, 2024

INDUSTRY Virtual takes place on May 2nd — which includes: Broadcasts of some of our favorite conference talks from the past year from Petra Wille, Kate Leto, Quincy Olatunde, and others — with live

Navigating the Digital Thread: Join Our Exclusive Webinar!

Tuesday, April 16, 2024

Enhancing Collaboration and Efficiency with Windchill, Creo, and Codebeamer View this email in your browser engineering.com Navigating the Digital Thread: Enhancing Collaboration and Efficiency with

Daily Coding Problem: Problem #1414 [Easy]

Tuesday, April 16, 2024

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Bloomberg. Determine whether there exists a one-to-one character mapping from one string

Charted | The Declining Value of the U.S. Federal Minimum Wage 📉

Tuesday, April 16, 2024

This graphic compares the nominal vs. inflation-adjusted value of the US minimum wage, from 1940 to 2023. View Online | Subscribe Presented by: The economy is changing. Is your portfolio adapting? >

⚙️ Limitless

Tuesday, April 16, 2024

Plus: OpenAI Japan takeover ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

The latest Go developer survey results are in

Tuesday, April 16, 2024

Plus lots of database stuff, a new Go book is in print, and a Minesweeper implementation. | #​503 — April 16, 2024 Unsub | Web Version If you wondered why you didn't get an issue last week, we took