Question
SQL Given a daily login table (table_login), including date (dt) and userid (uid). date is formmating as 'yyyy-mm-dd' SELECT 1.everyday, 2.the active user of the
SQL
Given a daily login table (table_login), including date (dt) and userid (uid).
date is formmating as 'yyyy-mm-dd'
SELECT 1.everyday, 2.the active user of the day, 3.the user that logged one day and also logged in next 7 days.
For 3, we want the users that logged in today, and then they also logged in any day of the next 2-7 days.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Databases In Telecommunications Ii Vldb 2001 International Workshop Dbtel 2001 Rome Italy September 10 2001 Proceedings Lncs 2209
Authors: Willem Jonker
2001st Edition
354042623X, 978-3540426233
