Query: formula1_team_standings_by_conference

select
  constructors.name as "team",
  count(case when position = 1 then 1 end) as "wins",
  count(case when position > 1 then 1 end) as "losses"
from
  constructor_standings
join constructors on constructor_standings.constructorId = constructors.constructorId
group by
  constructor_standings.constructorId
order by
  "wins" desc;