Anzahl User die sich vor mir angemeldet haben und im Mai 2023 aktiv waren

This query is marked as a draft This query has been published by Wurgl.

Anzahl User die sich vor mir angemeldet haben und im Mai 2023 bzw. danach aktiv waren

SQL

SELECT COUNT(DISTINCT u.user_id)
  FROM user AS u, actor, revision, user AS Wurgl
 WHERE Wurgl.user_name = 'Wurgl'
   AND u.user_id = actor_user
   AND actor_id = rev_actor
   AND rev_timestamp > '20230501000000'
   AND (u.user_registration IS NULL
        OR u.user_registration < Wurgl.user_registration
       )

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...