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

Diff of /uni/COMP2400/q4.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.3 by apollock, Tue Aug 10 01:28:52 2004 UTC revision 1.4 by apollock, Tue Aug 10 11:50:42 2004 UTC
# Line 12  COLUMN Name HEADING 'Name' Line 12  COLUMN Name HEADING 'Name'
12  COLUMN BirthDate HEADING 'Birthdate'  COLUMN BirthDate HEADING 'Birthdate'
13  COLUMN AgeAtDeath HEADING 'Age at death'  COLUMN AgeAtDeath HEADING 'Age at death'
14    
15  SELECT Firstname || ' ' || Surname AS NAME, BirthDate, ROUND((DeathDate - BirthDate) / 365, 1) AS AgeAtDeath  SELECT INITCAP(Firstname || ' ' || Surname) AS NAME, BirthDate, ROUND((DeathDate - BirthDate) / 365, 1) AS AgeAtDeath
16  FROM Person  FROM Person
17  WHERE DeathDate IS NOT NULL  WHERE DeathDate IS NOT NULL
18  ORDER BY BirthDate;  ORDER BY BirthDate;
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.22