uni/COMP2400/q3.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';

COLUMN Name HEADING 'Name'
COLUMN Birthdate HEADING 'Birthdate'

SELECT Firstname || ' ' || Surname AS Name, Birthdate
FROM Person
WHERE PersonId NOT IN (SELECT PersonId
                        FROM Parents);
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	apollock	1.2	ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';
8
9			COLUMN Name HEADING 'Name'
10			COLUMN Birthdate HEADING 'Birthdate'
11
12			SELECT Firstname \|\| ' ' \|\| Surname AS Name, Birthdate
13	apollock	1.1	FROM Person
14			WHERE PersonId NOT IN (SELECT PersonId
15			FROM Parents);