0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

-- Enter Query Title
-- Enter Query Description
--Kotlin, Go, Rust  Nim
--select count(id) from posts where tags LIKE '%<kotlin>%'or tags LIKE '%<kotlin-%'
   
   --select Count(case when (tags LIKE '%<kotlin>%'or tags LIKE '%<kotlin-%') and (tags not like '%android%') Then 1 End) from posts
   --select tags from posts where (tags LIKE '%<kotlin>%'or tags LIKE '%<kotlin-%') and (tags not like '%android%')
   
   --select top(10) id, reputation, displayName, location from Users where location like '%Israel%' order by  reputation desc
   
   --postTypeId = 1, best question is where there are most upvotes (votes.VoteTypeId = 2)

--select * from posts where (postTypeId =1) 

select top(100) x.postid, x.upVotes, p.title
from(
  select pf.postid, count(case when pf.VoteTypeId = 2 Then 1 End) as upVotes
  from PostFeedback pf 
  Group by postid) x ,posts p
where x.postid =p.id and p.postTypeId =1
Order by upVotes desc

fork query

edited aug 5

created aug 5 anonymous