select Count(case when tags LIKE '%<kotlin>%'or tags LIK...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

-- 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-%' Then 1 End) as Kotlin,
   Count(case when tags LIKE '%<go>%'or tags LIKE '%<go-%' Then 1 End) as Go,
   Count(case when tags LIKE '%<rust>%'or tags LIKE '%<rust-%' Then 1 End) as Rust,
   Count(case when tags LIKE '%<nim>%'or tags LIKE '%<nim-%' Then 1 End) as Nim
         from posts

Enter Parameters

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