Stack Exchange Data Explorer
Dec 3 at 9:27
select top 100 datediff(year, u.creationdate, p.creationd...
select * from posts where id=2970;
select tagid, count(*) as count from posttags group by ta...
select count(*) from ( select 1 res from users u left joi...
select count(*) from users u where id not in (select p.ow...
select count(*) from users where year(creationdate)<2019
select * from users where id is null;
4 Task (in 1 query)
3 task (in 1 query)
select count(displayname) from (SELECT displayname from u...
select top 10 * from users
select displayname from users u join posts p on u.id = p....
select * from posttypes
select count(*) from posts p where year(creationdate)=201...
site design / logo © 2019 Stack Exchange Inc; user contributions licensed under
cc by-sa 3.0