Posts by Carlos sousa • 1 point

• -1

  votes

  3

  answers

  2562

  views

  A: Sum the values of a Count(*) in sql

  SELECT country, total, sum(total) over () From (select A.Parents, Count(*) as total from Airports A left Join Estacoes E on A.Acronym = E.ICAO Where E.ICAO IS NULL group by A.Pais order by Pais) t;…

  sql postgresql

  answered 7 years, 1 month ago Carlos sousa 1