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

Annotation of /uni/COMP2400/q4.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.5 - (hide 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 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 apollock 1.5 TTITLE "COMP2400: Assignment 1: Question 4|Andrew Pollock (41347129)"
10 apollock 1.3
11 apollock 1.2 COLUMN Name HEADING 'Name'
12     COLUMN BirthDate HEADING 'Birthdate'
13     COLUMN AgeAtDeath HEADING 'Age at death'
14    
15 apollock 1.4 SELECT INITCAP(Firstname || ' ' || Surname) AS NAME, BirthDate, ROUND((DeathDate - BirthDate) / 365, 1) AS AgeAtDeath
16 apollock 1.1 FROM Person
17     WHERE DeathDate IS NOT NULL
18     ORDER BY BirthDate;
19 apollock 1.3
20     EXIT;

  ViewVC Help
Powered by ViewVC 1.1.22