Posts by Alcachofra • 29 points

2 posts

-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 4 years 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 4 years ago Alcachofra 29