Experienced users and newcomers

SQL

SET @minEdits = 0; -- 1) number of edits the user has to have to be considered experienced
SET @minTenureDays = 365; -- 2) if the user registered @minTenureDays days prior to the event (@eventDate), they're experienced
SET @eventDate = '20230101000000'; -- 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 (
  'Petr1888',
  'JiriMatejicek',
  'Palickap',
  'Packa',
  'Jáneček42',
  'Jitka Radimska',
  'Veronika.kasparkova',
  'Vojtasafr',
  'Luciefoto',
  'SteinsplitterBot',
  'Richard Sekerak (WMCZ)',
  'Slavek78',
  'Grossmelmen',
  'Lukbai',
  'Jst72',
  'Natyp1',
  'Pavbe',
  'Dirillo',
  'ZSsen',
  'Rogalo1',
  'Jan Puci'
  
)
SQL

Checking query status...
