Answers for "count record in same name condition"

SQL

0

count record in same name condition

select  t1.candidate
from (select count(Winner_loser_indic) as win, candidate from election where Winner_loser_indic ='W' group by candidate) t1
  inner join (select count(Winner_loser_indic) as lose, candidate from election where Winner_loser_indic ='L' group by candidate) t2
     on t1.candidate = t2.candidate
where t1.win = t2.lose

Posted by: Guest on February-20-2022

Code answers related to "count record in same name condition"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#