select * from( select postid, count(case when VoteTy...

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

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 * from(
select postid, count(case when VoteTypeId = 2 Then 1 End) as upVotes
from PostFeedback 
Group by postid) x

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results