Fork of
Experienced users and newcomers
by Martin Urbanec
This query is marked as a draft
This query has been published
by Janbery.
SQL
AخA
SET @minEdits = 0; -- 1) number of edits the user has to have to be considered experienced
SET @minTenureDays = 10; -- 2) if the user registered @minTenureDays days prior to the event (@eventDate), they're experienced
SET @eventDate = '20220821000000'; -- 3) see @minTenureDays
SELECT
user_name,
user_editcount,
IF(user_registration IS NOT NULL, user_registration, 'Unknown') AS user_registration,
IF(
(
-- have at least @minEdits edits
user_editcount >= @minEdits AND (
-- user_registration is not populated for users who registered pre-2005
user_registration IS NULL OR
-- are registered for at least @minTenureDays
DATEDIFF(@eventDate, user_registration) >= @minTenureDays
)
),
""Experienced"",
""Newcomer""
) AS is_newcomer
FROM user
WHERE user_name IN (
'janbery','Martin Urbanec',
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.