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.

Checking query status...