Employee survey results

InterviewQs

Employee survey results

SQL Database Querying

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

You're consulting for a company, and you've sent out a survey that asks successive qustions randomly. The survey logs data into a table called survey_logging. The schema of the table is:


Column Name Data Type Description
employee_id integer employee id of the survey respondant
action string Will be one of the following values, 'view', 'answer', 'skip'
question_id integer ID of the question asked
answer_id integer ID of the answer askedD
timestamp integer time stamp of the action made by respondant

Using SQL, find which question has the highest response rate.


 

Congratulations! You’ve accumulated 161 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

Consumer complaints on financial products

Monday, July 12, 2021

Data Analysis, Python, Pandas, Data Manipulation, External Dataset, InterviewQs Consumer complaints on financial products Data Analysis Python Pandas Data Manipulation External Dataset Forward this

Subarrays having a sum of p

Saturday, July 10, 2021

Python, Data Structures, Arrays, InterviewQs Subarrays having a sum of p Python Data Structures Arrays Forward this email to a friend or colleague and challenge them to solve it. Suppose you have an

Delivery times

Saturday, July 10, 2021

Data Analysis, Python, Pandas, T-test, InterviewQs Delivery times Data Analysis Python Pandas T-test Forward this email to a friend or colleague and challenge them to solve it. Suppose you are working

State populations

Monday, July 5, 2021

SQL, Database Querying, Window Function, InterviewQs State populations SQL Database Querying Window Function Forward this email to a friend or colleague and challenge them to solve it. Suppose you come

Candy production increase

Friday, July 2, 2021

Data Analysis, Python, Pandas, Statistics, T-test, External Dataset, InterviewQs Candy production increase Data Analysis Python Pandas Statistics T-test External Dataset Forward this email to a friend

JSK Weekly - August 05, 2021

Thursday, August 5, 2021

Happy Work Like A Dog Day everyone! Depending on what kind of dog you have, that could either mean hard working, lazing around all day or just simply playing in the sun all day but which ever it is,

The numbers don't lie | Act now to save on Disrupt passes

Thursday, August 5, 2021

Don't miss out on $100 savings before Friday Your Logo Disrupt Email Header. Event is September 21 to 23 Sign up to network with 10k TechCrunch enthusiasts at Disrupt Great news for budget-

A terminal dashboard for K8s, semantic grep for code, and a GitHub/GitLab alternative

Thursday, August 5, 2021

StackShare Weekly Email not displaying correctly? View it in your browser. StackShare Weekly Digest August 5th, 2021 Sponsored by CircleCI. Let CircleCI focus on CI/CD, so you can build the next big

Infographic | Visualizing the 4,000-Year History of Global Power 💪

Thursday, August 5, 2021

We examine an ambitious timeline that details the power of various civilizations going all the way back to 2000 BC TIMELESS Histomap: Visualizing the 4000 Year History of Global Power We examine an

Issue 175 - Tesla's mobile app redesign

Thursday, August 5, 2021

🎨 View this email in your browser If you are just now finding out about Tesletter, you can subscribe here! If you already know Tesletter and want to support us, check out our Patreon page If you have

 Automate The Planet- Compelling Tuesday

Thursday, August 5, 2021

Compelling Tuesday xUnit Tutorial | Part 7 | Geolocation Testing Using xUnit The last module of my XUnit course. There I discuss what Geolocation testing is and how to write such automated tests. Check

Programmer Weekly - Issue 66

Thursday, August 5, 2021

View this email in your browser Programmer Weekly Welcome to issue 66 of Programmer Weekly. Let's get straight to the links this week. From Our Sponsor Retool: The Fastest Way To Build Internal

Daily Coding Problem: Problem #486 [Medium]

Thursday, August 5, 2021

Daily Coding Problem Good morning! Here's a solution to yesterday's problem. This is your coding interview problem for today. This problem was asked by Pinterest. At a party, there is a single

New Course: Integrate Combine Into an App!

Thursday, August 5, 2021

Hey there! We have a new course for you. 🎥 Integrate Combine Into an App iOS & SWIFT • 27 MIN • INTERMEDIATE Check it out! Learn Combine in iOS by practice—while building a Chuck Norris jokes app!

Python Weekly - Issue 511

Thursday, August 5, 2021

View this email in your browser Python Weekly Welcome to issue 511 of Python Weekly. Let's get straight to the links this week. From Our Sponsor SonarLint Free and Open Source IDE Extension for