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