Data Interview Qs - Percent of months logged in

InterviewQs

Percent of months logged in

SQL Database Querying Subquery WITH Statement

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

Hi, 

You're given the following table showing user logins to your system:

Table: login_info

user_id date
13412 2020-01-05
13412 2020-04-25
13412 2020-08-31
13412 2020-09-02
... ...

Using the table above, write a SQL query that returns percent of months each user has logged in to your system. Your numerator will be the number of months a user has logged in, and your denominator will be the total number of months that a user has been registered in your system (here you can use the user's last login - first login as a proxy for this metric).

Here's an example of what your output table should look like:

user_id pct_months
13412 X%
23809389 Y%

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


 

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

Foggiest months

Monday, October 10, 2022

Data Analysis, Python, Pandas, Data Manipulation, Data Visualization, External Dataset, InterviewQs Foggiest months Data Analysis Python Pandas Data Manipulation Data Visualization External Dataset

Results of anonymous function

Friday, October 7, 2022

Python, Algorithms, Data Structures, Arrays, Anonymous Functions, InterviewQs Results of anonymous function Python Algorithms Data Structures Arrays Anonymous Functions Forward this email to a friend

Gender probability

Wednesday, October 5, 2022

Statistics, Probability Theory, InterviewQs Gender probability Statistics Probability Theory Forward this email to a friend or colleague and challenge them to solve it. Hi, Suppose a couple has three

Sock sorting in SQL

Monday, October 3, 2022

SQL, Database Querying, Subquery, Case Statement, InterviewQs Sock sorting in SQL SQL Database Querying Subquery Case Statement Forward this email to a friend or colleague and challenge them to solve

Creating a quick data pipeline

Friday, September 30, 2022

Python, Pandas, Data Pipeline, Chaining Functions, Data Processing, InterviewQs Creating a quick data pipeline Python Pandas Data Pipeline Chaining Functions Data Processing Forward this email to a

You Might Also Like

Power BI Weekly #256 - 1st May 2024

Wednesday, May 1, 2024

Power BI Weekly Newsletter Issue #256 powered by endjin Welcome to the 256th edition of Power BI Weekly! No announcements this week, so we'll jump straight into the highlighted articles. Firstly,

Apple AI browser 🌎, Tesla fires Supercharger team ⚡,  new sudo replacement 👨‍💻

Wednesday, May 1, 2024

Apple is testing a version of its Safari web browser that includes an AI-powered tool called Intelligent Search Sign Up |Advertise|View Online TLDR Together With Modern Treasury TLDR 2024-05-01 The

JSter #218 - Libraries and more

Wednesday, May 1, 2024

All JavaScript is good JavaScript. I'm close to done with my SurviveJS rework. The new site will have more content while being much lighter and faster to compile so that's all good. Libraries

BetterDev #258 - Build an 8-bit computer from scratch and Home automation with ESP8266

Wednesday, May 1, 2024

Better Dev #258 Apr 30, 2024 Hi all, We come back with a new issue this week. If you like BetterDev, please help spead word out by refer to your friends. Buy me a coffee would be great too. Build an 8-

Interface Interference 👎

Wednesday, May 1, 2024

Amid the AI device dunking, should everything “just be an app”? Here's a version for your browser. Hunting for the end of the long tail • April 30, 2024 Interface Interference The problem

Some Tesla Supercharger jobs get a jolt

Tuesday, April 30, 2024

Plus: Amazon CodeWhisperer changes its name and Arc gets a Windows version View this email online in your browser By Christine Hall Tuesday, April 30, 2024 Welcome to TechCrunch PM, bringing you the

Relief From Tinnitus: Free Discovery Call!

Tuesday, April 30, 2024

Do you suffer from tinnitus or a ringing in your ears? 1 in 3 adults over the age of 65 will suffer from this condition and often don't know there are things you can do to help. Our friends at

WebAIM April 2024 Newsletter

Tuesday, April 30, 2024

WebAIM April 2024 Newsletter Read this newsletter online at https://webaim.org/newsletter/2024/april Feature Web Accessibility in the 2024 Presidential Campaigns WebAIM's John Northup ran the US

👀 Being More Productive on a Smaller Screen — How to Hide Games on Steam Family Sharing

Tuesday, April 30, 2024

Also: What to Expect From Apple's "Let Loose" Event, and More! How-To Geek Logo April 30, 2024 Did You Know The letter J is the only letter that makes no appearance on the Periodic Table.

PEP 686, Lazy Evaluation, Serverless Python, and More

Tuesday, April 30, 2024

PEP 686: Make UTF-8 Mode Default #627 – APRIL 30, 2024 VIEW IN BROWSER The PyCoder's Weekly Logo PEP 686: Make UTF-8 Mode Default This Python Enhancement Proposal outlines making UTF-8 the default