jon.doe32071
|
Registered User
|
- select count(u.id) from Users u
- SELECT p.OwnerUserId AS UserId, u.DisplayName, SUM(CASE W...
- WITH MonthlyData AS ( SELECT FORMAT(p.CreationDate, 'yyyy...
- SELECT FORMAT(CreationDate, 'yyyy-MM') AS MonthYear, SUM(...
- DECLARE @PeriodStart DATE = '2022-11-01'; DECLARE @Period...
- one month reputation active users
- DECLARE @PeriodStart DATE = '2020-12-01'; DECLARE @Period...
- DECLARE @PeriodStart DATE = '2022-12-01'; DECLARE @Period...
- DECLARE @Period1Start DATE = '2020-11-29'; DECLARE @Perio...
- # of active users prior to and after chatgpt
- DECLARE @ChatGPTRelease DATE = '2022-11-30'; DECLARE @Per...
- SELECT YEAR(q.CreationDate) AS Year, COUNT(DISTINCT CASE ...
- unaccepted answers per year
- SELECT YEAR(q.CreationDate) AS year, COUNT(CASE WHEN a.Ac...
- Popular programming languages per over time - EverSQL.com