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

ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';

TTITLE "COMP2400: Assignment 1: Question 4|Andrew Pollock (41347129)"

COLUMN Name HEADING 'Name'
COLUMN BirthDate HEADING 'Birthdate'
COLUMN AgeAtDeath HEADING 'Age at death'

SELECT INITCAP(Firstname || ' ' || Surname) AS NAME, BirthDate, ROUND((DeathDate - BirthDate) / 365, 1) AS AgeAtDeath
FROM Person
WHERE DeathDate IS NOT NULL
ORDER BY BirthDate;

EXIT;
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	ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';
8
9	TTITLE "COMP2400: Assignment 1: Question 4\|Andrew Pollock (41347129)"
10
11	COLUMN Name HEADING 'Name'
12	COLUMN BirthDate HEADING 'Birthdate'
13	COLUMN AgeAtDeath HEADING 'Age at death'
14
15	SELECT INITCAP(Firstname \|\| ' ' \|\| Surname) AS NAME, BirthDate, ROUND((DeathDate - BirthDate) / 365, 1) AS AgeAtDeath
16	FROM Person
17	WHERE DeathDate IS NOT NULL
18	ORDER BY BirthDate;
19
20	EXIT;