uni/COMP2400/q4.sql

-- I have read the ANU Code on "Academic Honesty in Learning and Teaching",
-- and I declare that, except where appropriately attributed, the content
-- of the file I have submitted for this assignment is entirely my own
-- work. It has not been produced, in whole or in part, by another person.
-- (signed) Andrew Pollock 4137129

SELECT Firstname || Surname AS NAME, BirthDate, DeathDate - BirthDate AS AgeAtDeath
FROM Person
WHERE DeathDate IS NOT NULL
ORDER BY BirthDate;
1	apollock	1.1	-- I have read the ANU Code on "Academic Honesty in Learning and Teaching",
2			-- and I declare that, except where appropriately attributed, the content
3			-- of the file I have submitted for this assignment is entirely my own
4			-- work. It has not been produced, in whole or in part, by another person.
5			-- (signed) Andrew Pollock 4137129
6
7			SELECT Firstname \|\| Surname AS NAME, BirthDate, DeathDate - BirthDate AS AgeAtDeath
8			FROM Person
9			WHERE DeathDate IS NOT NULL
10			ORDER BY BirthDate;