Posts by Alcachofra • 29 points

• -1

  votes

  1

  answer

  59

  views

  Q: Which country had the largest total population each year

  I created this table: CREATE TABLE `Populacao` ( `ano` int(11) NOT NULL, `pais` varchar(2) NOT NULL, `popM` varchar(10) DEFAULT NULL, `popF` varchar(10) DEFAULT NULL, ); Where popM is the male…

  mysql sql query select

  asked 3 years, 11 months ago Alcachofra 29

• 0

  votes

  1

  answer

  32

  views

  Q: Find the year in which total customers (sum) was higher

  I’m using sqlite, and I have a table like: year | clients ---- | ------- 2000 | 1 2000 | 2 1999 | 3 1999 | 5 2000 | 4 1999 | 6 This is just one example. I want to find the year when the total of…

  sql select sqlite

  asked 3 years, 11 months ago Alcachofra 29