/[cvs.andrew.net.au]/uni/COMP2400/q4.sql
ViewVC logotype

Contents of /uni/COMP2400/q4.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.5 - (show annotations)
Wed Aug 11 22:48:11 2004 UTC (18 years, 1 month ago) by apollock
Branch: MAIN
CVS Tags: HEAD
Changes since 1.4: +1 -1 lines
Base questions ready for submission

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;

  ViewVC Help
Powered by ViewVC 1.1.22