Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
DB QA Test Tasks Answers
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
--First select ua.Date, ua.UserId, ROW_NUMBER() OVER(PARTITION BY userid ORDER BY date) as LoginIndex from test.dbo.UserActivity ua order by ua.Date --Third select ur.UserID, ur.Date as DateReg, COUNT(ur.UserID) over (partition by ur.Date) RegDay, --ua.UserID, ua.DateEnter, --DATEDIFF( D, ur.Date, ua.DateEnter ) as Betw, --case when DATEDIFF( D, ur.Date, ua.DateEnter )=7 then 1 else 0 end as fl_week, --sum(case when DATEDIFF( D, ur.Date, ua.DateEnter )=7 then 1 else 0 end) over (partition by ur.date) as PlayWeek, (sum(case when DATEDIFF( D, ur.Date, ua.DateEnter )=7 then 1 else 0 end) over (partition by ur.date)) * 100 / COUNT(ur.UserID) over (partition by ur.Date) Procent from test.dbo.UserRegistrations ur full join (select UserID, MIN(Date) as DateEnter from test.dbo.UserActivity group by UserID) as ua on ur.UserID=ua.UserID order by ur.Date,ur.UserID, ua.DateEnter
View schema
Absolute service time: 0,16 sec, absolute service time: 0,16 sec
latest
|
history
Error(s), warning(s):
Invalid object name 'UserActivity'.