Q&A for scientists using computers to solve scientific problems
/*select top 100 * from posts order by (select reputation from users where users.id = posts.owneruserid) desc*/ /*select top 100 * from users where not exists(select * from posts where users.id = posts.owneruserid and year(creationdate)=2020)*/ /*select * from posts where owneruserid = 42 order by creationdate desc*/ /*select top 100 * from posts as p full join users u on p.owneruserid = u.id*/ /*select top 100 * from (select * from posts where score <= 100) as t join users as u on t.owneruserid=u.id*/ /*with t as (select * from users where reputation>100) select * from t as t1 join t as t2 on ...*/ /*select * from (select * from ususers where reputation>100) as t1 join (select * from ususers where reputation>100) as t2 on ...*/ /*select top 5 id, displayname from users intersect select top 5 id, title from posts*/ --select case when --(select count(*) from posts)>1 then 'aaa' else 'bbb' end select top 10 *, reputation + case when score is null then 0 else score end from users as u left join posts as p on p.owneruserid = u.id