Skip to content
sql
SELECT Name, FirstName FROM People ORDER BY BirthYear ASC LIMIT 4 OFFSET 1;
SELECT MIN(BirthYear) AS minBirthYear FROM People;
SELECT COUNT(BirthYear) AS bornInThisYear FROM People WHERE BirthYear = 2;
SELECT AVG(BirthYear) AS averageBirthYear FROM People;
SELECT AVG(BirthYear)*2 AS averageBirthYear FROM People;
SELECT COUNT(BirthYear), BirthYear/100 AS "Siècle" FROM People GROUP BY BirthYear/100;

Released under the GPL-3.0 License.