Oracle Live SQL - Script: Analytics

Statement 1

alter session set nls_date_format = 'DD-MON-YYYY'

Statement processed.

Statement 2

drop table life_expectancy purge

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 3

create table life_expectancy ( recorded_year date, age number(6,2) )

Table created.

Statement 4

insert into life_expectancy values (date '1543-01-01',33.94)

1 row(s) inserted.

Statement 5

insert into life_expectancy values (date '1548-01-01',38.82)

1 row(s) inserted.

Statement 6

insert into life_expectancy values (date '1553-01-01',39.59)

1 row(s) inserted.

Statement 7

insert into life_expectancy values (date '1558-01-01',22.38)

1 row(s) inserted.

Statement 8

insert into life_expectancy values (date '1563-01-01',36.66)

1 row(s) inserted.

Statement 9

insert into life_expectancy values (date '1568-01-01',39.67)

1 row(s) inserted.

Statement 10

insert into life_expectancy values (date '1573-01-01',41.06)

1 row(s) inserted.

Statement 11

insert into life_expectancy values (date '1578-01-01',41.56)

1 row(s) inserted.

Statement 12

insert into life_expectancy values (date '1583-01-01',42.7)

1 row(s) inserted.

Statement 13

insert into life_expectancy values (date '1588-01-01',37.05)

1 row(s) inserted.

Statement 14

insert into life_expectancy values (date '1593-01-01',38.05)

1 row(s) inserted.

Statement 15

insert into life_expectancy values (date '1598-01-01',37.82)

1 row(s) inserted.

Statement 16

insert into life_expectancy values (date '1603-01-01',38.53)

1 row(s) inserted.

Statement 17

insert into life_expectancy values (date '1608-01-01',39.59)

1 row(s) inserted.

Statement 18

insert into life_expectancy values (date '1613-01-01',36.79)

1 row(s) inserted.

Statement 19

insert into life_expectancy values (date '1618-01-01',40.31)

1 row(s) inserted.

Statement 20

insert into life_expectancy values (date '1623-01-01',33.39)

1 row(s) inserted.

Statement 21

insert into life_expectancy values (date '1628-01-01',39.69)

1 row(s) inserted.

Statement 22

insert into life_expectancy values (date '1633-01-01',39.72)

1 row(s) inserted.

Statement 23

insert into life_expectancy values (date '1638-01-01',34.03)

1 row(s) inserted.

Statement 24

insert into life_expectancy values (date '1643-01-01',36.32)

1 row(s) inserted.

Statement 25

insert into life_expectancy values (date '1648-01-01',39.74)

1 row(s) inserted.

Statement 26

insert into life_expectancy values (date '1653-01-01',39.14)

1 row(s) inserted.

Statement 27

insert into life_expectancy values (date '1658-01-01',33.04)

1 row(s) inserted.

Statement 28

insert into life_expectancy values (date '1663-01-01',33.27)

1 row(s) inserted.

Statement 29

insert into life_expectancy values (date '1668-01-01',32.48)

1 row(s) inserted.

Statement 30

insert into life_expectancy values (date '1673-01-01',37.41)

1 row(s) inserted.

Statement 31

insert into life_expectancy values (date '1678-01-01',32.4)

1 row(s) inserted.

Statement 32

insert into life_expectancy values (date '1683-01-01',31.27)

1 row(s) inserted.

Statement 33

insert into life_expectancy values (date '1688-01-01',35.93)

1 row(s) inserted.

Statement 34

insert into life_expectancy values (date '1693-01-01',36.35)

1 row(s) inserted.

Statement 35

insert into life_expectancy values (date '1698-01-01',38.06)

1 row(s) inserted.

Statement 36

insert into life_expectancy values (date '1703-01-01',38.47)

1 row(s) inserted.

Statement 37

insert into life_expectancy values (date '1708-01-01',38.5)

1 row(s) inserted.

Statement 38

insert into life_expectancy values (date '1713-01-01',36.89)

1 row(s) inserted.

Statement 39

insert into life_expectancy values (date '1718-01-01',35.75)

1 row(s) inserted.

Statement 40

insert into life_expectancy values (date '1723-01-01',35.49)

1 row(s) inserted.

Statement 41

insert into life_expectancy values (date '1728-01-01',25.34)

1 row(s) inserted.

Statement 42

insert into life_expectancy values (date '1733-01-01',36.34)

1 row(s) inserted.

Statement 43

insert into life_expectancy values (date '1738-01-01',35.26)

1 row(s) inserted.

Statement 44

insert into life_expectancy values (date '1743-01-01',34.27)

1 row(s) inserted.

Statement 45

insert into life_expectancy values (date '1748-01-01',36.47)

1 row(s) inserted.

Statement 46

insert into life_expectancy values (date '1753-01-01',39.77)

1 row(s) inserted.

Statement 47

insert into life_expectancy values (date '1758-01-01',38.12)

1 row(s) inserted.

Statement 48

insert into life_expectancy values (date '1763-01-01',35.37)

1 row(s) inserted.

Statement 49

insert into life_expectancy values (date '1768-01-01',36.19)

1 row(s) inserted.

Statement 50

insert into life_expectancy values (date '1773-01-01',39.09)

1 row(s) inserted.

Statement 51

insert into life_expectancy values (date '1778-01-01',37.74)

1 row(s) inserted.

Statement 52

insert into life_expectancy values (date '1783-01-01',35.81)

1 row(s) inserted.

Statement 53

insert into life_expectancy values (date '1788-01-01',38.97)

1 row(s) inserted.

Statement 54

insert into life_expectancy values (date '1793-01-01',37.92)

1 row(s) inserted.

Statement 55

insert into life_expectancy values (date '1798-01-01',38.93)

1 row(s) inserted.

Statement 56

insert into life_expectancy values (date '1803-01-01',40.02)

1 row(s) inserted.

Statement 57

insert into life_expectancy values (date '1808-01-01',40.58)

1 row(s) inserted.

Statement 58

insert into life_expectancy values (date '1813-01-01',41.25)

1 row(s) inserted.

Statement 59

insert into life_expectancy values (date '1818-01-01',40.84)

1 row(s) inserted.

Statement 60

insert into life_expectancy values (date '1823-01-01',40.47)

1 row(s) inserted.

Statement 61

insert into life_expectancy values (date '1828-01-01',41.43)

1 row(s) inserted.

Statement 62

insert into life_expectancy values (date '1833-01-01',40.89)

1 row(s) inserted.

Statement 63

insert into life_expectancy values (date '1838-01-01',40.56)

1 row(s) inserted.

Statement 64

insert into life_expectancy values (date '1842-01-01',40.995)

1 row(s) inserted.

Statement 65

insert into life_expectancy values (date '1843-01-01',41.56)

1 row(s) inserted.

Statement 66

insert into life_expectancy values (date '1844-01-01',41.24)

1 row(s) inserted.

Statement 67

insert into life_expectancy values (date '1845-01-01',42.17)

1 row(s) inserted.

Statement 68

insert into life_expectancy values (date '1846-01-01',40.15)

1 row(s) inserted.

Statement 69

insert into life_expectancy values (date '1847-01-01',38.515)

1 row(s) inserted.

Statement 70

insert into life_expectancy values (date '1848-01-01',39.89)

1 row(s) inserted.

Statement 71

insert into life_expectancy values (date '1849-01-01',37.68)

1 row(s) inserted.

Statement 72

insert into life_expectancy values (date '1850-01-01',42.77)

1 row(s) inserted.

Statement 73

insert into life_expectancy values (date '1851-01-01',40.95)

1 row(s) inserted.

Statement 74

insert into life_expectancy values (date '1852-01-01',40.41)

1 row(s) inserted.

Statement 75

insert into life_expectancy values (date '1853-01-01',39.985)

1 row(s) inserted.

Statement 76

insert into life_expectancy values (date '1854-01-01',39.48)

1 row(s) inserted.

Statement 77

insert into life_expectancy values (date '1855-01-01',40.74)

1 row(s) inserted.

Statement 78

insert into life_expectancy values (date '1856-01-01',42.47)

1 row(s) inserted.

Statement 79

insert into life_expectancy values (date '1857-01-01',40.925)

1 row(s) inserted.

Statement 80

insert into life_expectancy values (date '1858-01-01',39.545)

1 row(s) inserted.

Statement 81

insert into life_expectancy values (date '1859-01-01',40.405)

1 row(s) inserted.

Statement 82

insert into life_expectancy values (date '1860-01-01',41.945)

1 row(s) inserted.

Statement 83

insert into life_expectancy values (date '1861-01-01',41.62)

1 row(s) inserted.

Statement 84

insert into life_expectancy values (date '1862-01-01',42.13)

1 row(s) inserted.

Statement 85

insert into life_expectancy values (date '1863-01-01',40.37)

1 row(s) inserted.

Statement 86

insert into life_expectancy values (date '1864-01-01',39.585)

1 row(s) inserted.

Statement 87

insert into life_expectancy values (date '1865-01-01',39.75)

1 row(s) inserted.

Statement 88

insert into life_expectancy values (date '1866-01-01',40.085)

1 row(s) inserted.

Statement 89

insert into life_expectancy values (date '1867-01-01',41.995)

1 row(s) inserted.

Statement 90

insert into life_expectancy values (date '1868-01-01',41.7)

1 row(s) inserted.

Statement 91

insert into life_expectancy values (date '1869-01-01',41.34)

1 row(s) inserted.

Statement 92

insert into life_expectancy values (date '1870-01-01',40.605)

1 row(s) inserted.

Statement 93

insert into life_expectancy values (date '1871-01-01',41.135)

1 row(s) inserted.

Statement 94

insert into life_expectancy values (date '1872-01-01',42.72)

1 row(s) inserted.

Statement 95

insert into life_expectancy values (date '1873-01-01',43.29)

1 row(s) inserted.

Statement 96

insert into life_expectancy values (date '1874-01-01',42.105)

1 row(s) inserted.

Statement 97

insert into life_expectancy values (date '1875-01-01',41.45)

1 row(s) inserted.

Statement 98

insert into life_expectancy values (date '1876-01-01',42.665)

1 row(s) inserted.

Statement 99

insert into life_expectancy values (date '1877-01-01',43.69)

1 row(s) inserted.

Statement 100

insert into life_expectancy values (date '1878-01-01',42.04)

1 row(s) inserted.

Statement 101

insert into life_expectancy values (date '1879-01-01',43.505)

1 row(s) inserted.

Statement 102

insert into life_expectancy values (date '1880-01-01',42.975)

1 row(s) inserted.

Statement 103

insert into life_expectancy values (date '1881-01-01',45.055)

1 row(s) inserted.

Statement 104

insert into life_expectancy values (date '1882-01-01',43.985)

1 row(s) inserted.

Statement 105

insert into life_expectancy values (date '1883-01-01',44.015)

1 row(s) inserted.

Statement 106

insert into life_expectancy values (date '1884-01-01',43.635)

1 row(s) inserted.

Statement 107

insert into life_expectancy values (date '1885-01-01',44.57)

1 row(s) inserted.

Statement 108

insert into life_expectancy values (date '1886-01-01',44.585)

1 row(s) inserted.

Statement 109

insert into life_expectancy values (date '1887-01-01',45.08)

1 row(s) inserted.

Statement 110

insert into life_expectancy values (date '1888-01-01',46.28)

1 row(s) inserted.

Statement 111

insert into life_expectancy values (date '1889-01-01',45.93)

1 row(s) inserted.

Statement 112

insert into life_expectancy values (date '1890-01-01',44.12)

1 row(s) inserted.

Statement 113

insert into life_expectancy values (date '1891-01-01',44.43)

1 row(s) inserted.

Statement 114

insert into life_expectancy values (date '1892-01-01',45.59)

1 row(s) inserted.

Statement 115

insert into life_expectancy values (date '1893-01-01',44.68)

1 row(s) inserted.

Statement 116

insert into life_expectancy values (date '1894-01-01',48.275)

1 row(s) inserted.

Statement 117

insert into life_expectancy values (date '1895-01-01',45.41)

1 row(s) inserted.

Statement 118

insert into life_expectancy values (date '1896-01-01',47.07)

1 row(s) inserted.

Statement 119

insert into life_expectancy values (date '1897-01-01',46.445)

1 row(s) inserted.

Statement 120

insert into life_expectancy values (date '1898-01-01',46.14)

1 row(s) inserted.

Statement 121

insert into life_expectancy values (date '1899-01-01',45.245)

1 row(s) inserted.

Statement 122

insert into life_expectancy values (date '1900-01-01',45.62)

1 row(s) inserted.

Statement 123

insert into life_expectancy values (date '1901-01-01',46.93)

1 row(s) inserted.

Statement 124

insert into life_expectancy values (date '1902-01-01',48.355)

1 row(s) inserted.

Statement 125

insert into life_expectancy values (date '1903-01-01',49.54)

1 row(s) inserted.

Statement 126

insert into life_expectancy values (date '1904-01-01',48.145)

1 row(s) inserted.

Statement 127

insert into life_expectancy values (date '1905-01-01',49.92)

1 row(s) inserted.

Statement 128

insert into life_expectancy values (date '1906-01-01',49.595)

1 row(s) inserted.

Statement 129

insert into life_expectancy values (date '1907-01-01',50.565)

1 row(s) inserted.

Statement 130

insert into life_expectancy values (date '1908-01-01',51.02)

1 row(s) inserted.

Statement 131

insert into life_expectancy values (date '1909-01-01',51.67)

1 row(s) inserted.

Statement 132

insert into life_expectancy values (date '1910-01-01',53.255)

1 row(s) inserted.

Statement 133

insert into life_expectancy values (date '1911-01-01',51.225)

1 row(s) inserted.

Statement 134

insert into life_expectancy values (date '1912-01-01',54.31)

1 row(s) inserted.

Statement 135

insert into life_expectancy values (date '1913-01-01',53.355)

1 row(s) inserted.

Statement 136

insert into life_expectancy values (date '1914-01-01',53.21)

1 row(s) inserted.

Statement 137

insert into life_expectancy values (date '1915-01-01',51.205)

1 row(s) inserted.

Statement 138

insert into life_expectancy values (date '1916-01-01',54.24)

1 row(s) inserted.

Statement 139

insert into life_expectancy values (date '1917-01-01',54.155)

1 row(s) inserted.

Statement 140

insert into life_expectancy values (date '1918-01-01',47.275)

1 row(s) inserted.

Statement 141

insert into life_expectancy values (date '1919-01-01',54.31)

1 row(s) inserted.

Statement 142

insert into life_expectancy values (date '1920-01-01',57.255)

1 row(s) inserted.

Statement 143

insert into life_expectancy values (date '1921-01-01',58.085)

1 row(s) inserted.

Statement 144

insert into life_expectancy values (date '1922-01-01',57.03)

1 row(s) inserted.

Statement 145

insert into life_expectancy values (date '1923-01-01',59.31)

1 row(s) inserted.

Statement 146

insert into life_expectancy values (date '1924-01-01',58.08)

1 row(s) inserted.

Statement 147

insert into life_expectancy values (date '1925-01-01',58.43)

1 row(s) inserted.

Statement 148

insert into life_expectancy values (date '1926-01-01',59.57)

1 row(s) inserted.

Statement 149

insert into life_expectancy values (date '1927-01-01',58.96)

1 row(s) inserted.

Statement 150

insert into life_expectancy values (date '1928-01-01',59.92)

1 row(s) inserted.

Statement 151

insert into life_expectancy values (date '1929-01-01',57.63)

1 row(s) inserted.

Statement 152

insert into life_expectancy values (date '1930-01-01',60.78)

1 row(s) inserted.

Statement 153

insert into life_expectancy values (date '1931-01-01',60.01)

1 row(s) inserted.

Statement 154

insert into life_expectancy values (date '1932-01-01',60.53)

1 row(s) inserted.

Statement 155

insert into life_expectancy values (date '1933-01-01',60.58)

1 row(s) inserted.

Statement 156

insert into life_expectancy values (date '1934-01-01',61.31)

1 row(s) inserted.

Statement 157

insert into life_expectancy values (date '1935-01-01',61.96)

1 row(s) inserted.

Statement 158

insert into life_expectancy values (date '1936-01-01',61.76)

1 row(s) inserted.

Statement 159

insert into life_expectancy values (date '1937-01-01',61.8)

1 row(s) inserted.

Statement 160

insert into life_expectancy values (date '1938-01-01',63.21)

1 row(s) inserted.

Statement 161

insert into life_expectancy values (date '1939-01-01',63.61)

1 row(s) inserted.

Statement 162

insert into life_expectancy values (date '1940-01-01',60.88)

1 row(s) inserted.

Statement 163

insert into life_expectancy values (date '1941-01-01',61.35)

1 row(s) inserted.

Statement 164

insert into life_expectancy values (date '1942-01-01',63.99)

1 row(s) inserted.

Statement 165

insert into life_expectancy values (date '1943-01-01',64.01)

1 row(s) inserted.

Statement 166

insert into life_expectancy values (date '1944-01-01',64.81)

1 row(s) inserted.

Statement 167

insert into life_expectancy values (date '1945-01-01',65.75)

1 row(s) inserted.

Statement 168

insert into life_expectancy values (date '1946-01-01',66.34)

1 row(s) inserted.

Statement 169

insert into life_expectancy values (date '1947-01-01',66.31)

1 row(s) inserted.

Statement 170

insert into life_expectancy values (date '1948-01-01',68.39)

1 row(s) inserted.

Statement 171

insert into life_expectancy values (date '1949-01-01',68.11)

1 row(s) inserted.

Statement 172

insert into life_expectancy values (date '1950-01-01',68.63)

1 row(s) inserted.

Statement 173

insert into life_expectancy values (date '1951-01-01',68.24)

1 row(s) inserted.

Statement 174

insert into life_expectancy values (date '1952-01-01',69.54)

1 row(s) inserted.

Statement 175

insert into life_expectancy values (date '1953-01-01',69.8)

1 row(s) inserted.

Statement 176

insert into life_expectancy values (date '1954-01-01',70.17)

1 row(s) inserted.

Statement 177

insert into life_expectancy values (date '1955-01-01',70.14)

1 row(s) inserted.

Statement 178

insert into life_expectancy values (date '1956-01-01',70.4)

1 row(s) inserted.

Statement 179

insert into life_expectancy values (date '1957-01-01',70.53)

1 row(s) inserted.

Statement 180

insert into life_expectancy values (date '1958-01-01',70.7)

1 row(s) inserted.

Statement 181

insert into life_expectancy values (date '1959-01-01',70.82)

1 row(s) inserted.

Statement 182

insert into life_expectancy values (date '1960-01-01',71.04)

1 row(s) inserted.

Statement 183

insert into life_expectancy values (date '1961-01-01',70.79)

1 row(s) inserted.

Statement 184

insert into life_expectancy values (date '1962-01-01',70.85)

1 row(s) inserted.

Statement 185

insert into life_expectancy values (date '1963-01-01',70.76)

1 row(s) inserted.

Statement 186

insert into life_expectancy values (date '1964-01-01',71.55)

1 row(s) inserted.

Statement 187

insert into life_expectancy values (date '1965-01-01',71.52)

1 row(s) inserted.

Statement 188

insert into life_expectancy values (date '1966-01-01',71.44)

1 row(s) inserted.

Statement 189

insert into life_expectancy values (date '1967-01-01',72.07)

1 row(s) inserted.

Statement 190

insert into life_expectancy values (date '1968-01-01',71.69)

1 row(s) inserted.

Statement 191

insert into life_expectancy values (date '1969-01-01',71.66)

1 row(s) inserted.

Statement 192

insert into life_expectancy values (date '1970-01-01',71.9)

1 row(s) inserted.

Statement 193

insert into life_expectancy values (date '1971-01-01',72.23)

1 row(s) inserted.

Statement 194

insert into life_expectancy values (date '1972-01-01',72)

1 row(s) inserted.

Statement 195

insert into life_expectancy values (date '1973-01-01',72.19)

1 row(s) inserted.

Statement 196

insert into life_expectancy values (date '1974-01-01',72.38)

1 row(s) inserted.

Statement 197

insert into life_expectancy values (date '1975-01-01',72.65)

1 row(s) inserted.

Statement 198

insert into life_expectancy values (date '1976-01-01',72.64)

1 row(s) inserted.

Statement 199

insert into life_expectancy values (date '1977-01-01',73.12)

1 row(s) inserted.

Statement 200

insert into life_expectancy values (date '1978-01-01',73.06)

1 row(s) inserted.

Statement 201

insert into life_expectancy values (date '1979-01-01',73.16)

1 row(s) inserted.

Statement 202

insert into life_expectancy values (date '1980-01-01',73.59)

1 row(s) inserted.

Statement 203

insert into life_expectancy values (date '1981-01-01',73.92)

1 row(s) inserted.

Statement 204

insert into life_expectancy values (date '1982-01-01',74.04)

1 row(s) inserted.

Statement 205

insert into life_expectancy values (date '1983-01-01',74.29)

1 row(s) inserted.

Statement 206

insert into life_expectancy values (date '1984-01-01',74.68)

1 row(s) inserted.

Statement 207

insert into life_expectancy values (date '1985-01-01',74.53)

1 row(s) inserted.

Statement 208

insert into life_expectancy values (date '1986-01-01',74.8)

1 row(s) inserted.

Statement 209

insert into life_expectancy values (date '1987-01-01',75.15)

1 row(s) inserted.

Statement 210

insert into life_expectancy values (date '1988-01-01',75.26)

1 row(s) inserted.

Statement 211

insert into life_expectancy values (date '1989-01-01',75.4)

1 row(s) inserted.

Statement 212

insert into life_expectancy values (date '1990-01-01',75.74)

1 row(s) inserted.

Statement 213

insert into life_expectancy values (date '1991-01-01',75.91)

1 row(s) inserted.

Statement 214

insert into life_expectancy values (date '1992-01-01',76.3)

1 row(s) inserted.

Statement 215

insert into life_expectancy values (date '1993-01-01',76.17)

1 row(s) inserted.

Statement 216

insert into life_expectancy values (date '1994-01-01',76.72)

1 row(s) inserted.

Statement 217

insert into life_expectancy values (date '1995-01-01',76.62)

1 row(s) inserted.

Statement 218

insert into life_expectancy values (date '1996-01-01',76.88)

1 row(s) inserted.

Statement 219

insert into life_expectancy values (date '1997-01-01',77.14)

1 row(s) inserted.

Statement 220

insert into life_expectancy values (date '1998-01-01',77.28)

1 row(s) inserted.

Statement 221

insert into life_expectancy values (date '1999-01-01',77.38)

1 row(s) inserted.

Statement 222

insert into life_expectancy values (date '2000-01-01',77.86)

1 row(s) inserted.

Statement 223

insert into life_expectancy values (date '2001-01-01',78.14)

1 row(s) inserted.

Statement 224

insert into life_expectancy values (date '2002-01-01',78.26)

1 row(s) inserted.

Statement 225

insert into life_expectancy values (date '2003-01-01',78.35)

1 row(s) inserted.

Statement 226

insert into life_expectancy values (date '2004-01-01',78.93)

1 row(s) inserted.

Statement 227

insert into life_expectancy values (date '2005-01-01',79.13)

1 row(s) inserted.

Statement 228

insert into life_expectancy values (date '2006-01-01',79.37)

1 row(s) inserted.

Statement 229

insert into life_expectancy values (date '2007-01-01',79.56)

1 row(s) inserted.

Statement 230

insert into life_expectancy values (date '2008-01-01',79.68)

1 row(s) inserted.

Statement 231

insert into life_expectancy values (date '2009-01-01',80.18)

1 row(s) inserted.

Statement 232

insert into life_expectancy values (date '2010-01-01',80.41)

1 row(s) inserted.

Statement 233

insert into life_expectancy values (date '2011-01-01',80.8)

1 row(s) inserted.

Statement 234

commit

Statement processed.

Statement 235

select * from  life_expectancy order by 1

 
RECORDED_YEAR AGE
01-JAN-1543 33.94
01-JAN-1548 38.82
01-JAN-1553 39.59
01-JAN-1558 22.38
01-JAN-1563 36.66
01-JAN-1568 39.67
01-JAN-1573 41.06
01-JAN-1578 41.56
01-JAN-1583 42.7
01-JAN-1588 37.05
01-JAN-1593 38.05
01-JAN-1598 37.82
01-JAN-1603 38.53
01-JAN-1608 39.59
01-JAN-1613 36.79
01-JAN-1618 40.31
01-JAN-1623 33.39
01-JAN-1628 39.69
01-JAN-1633 39.72
01-JAN-1638 34.03
01-JAN-1643 36.32
01-JAN-1648 39.74
01-JAN-1653 39.14
01-JAN-1658 33.04
01-JAN-1663 33.27
01-JAN-1668 32.48
01-JAN-1673 37.41
01-JAN-1678 32.4
01-JAN-1683 31.27
01-JAN-1688 35.93
01-JAN-1693 36.35
01-JAN-1698 38.06
01-JAN-1703 38.47
01-JAN-1708 38.5
01-JAN-1713 36.89
01-JAN-1718 35.75
01-JAN-1723 35.49
01-JAN-1728 25.34
01-JAN-1733 36.34
01-JAN-1738 35.26
01-JAN-1743 34.27
01-JAN-1748 36.47
01-JAN-1753 39.77
01-JAN-1758 38.12
01-JAN-1763 35.37
01-JAN-1768 36.19
01-JAN-1773 39.09
01-JAN-1778 37.74
01-JAN-1783 35.81
01-JAN-1788 38.97
01-JAN-1793 37.92
01-JAN-1798 38.93
01-JAN-1803 40.02
01-JAN-1808 40.58
01-JAN-1813 41.25
01-JAN-1818 40.84
01-JAN-1823 40.47
01-JAN-1828 41.43
01-JAN-1833 40.89
01-JAN-1838 40.56
01-JAN-1842 41
01-JAN-1843 41.56
01-JAN-1844 41.24
01-JAN-1845 42.17
01-JAN-1846 40.15
01-JAN-1847 38.52
01-JAN-1848 39.89
01-JAN-1849 37.68
01-JAN-1850 42.77
01-JAN-1851 40.95
01-JAN-1852 40.41
01-JAN-1853 39.99
01-JAN-1854 39.48
01-JAN-1855 40.74
01-JAN-1856 42.47
01-JAN-1857 40.93
01-JAN-1858 39.55
01-JAN-1859 40.41
01-JAN-1860 41.95
01-JAN-1861 41.62
01-JAN-1862 42.13
01-JAN-1863 40.37
01-JAN-1864 39.59
01-JAN-1865 39.75
01-JAN-1866 40.09
01-JAN-1867 42
01-JAN-1868 41.7
01-JAN-1869 41.34
01-JAN-1870 40.61
01-JAN-1871 41.14
01-JAN-1872 42.72
01-JAN-1873 43.29
01-JAN-1874 42.11
01-JAN-1875 41.45
01-JAN-1876 42.67
01-JAN-1877 43.69
01-JAN-1878 42.04
01-JAN-1879 43.51
01-JAN-1880 42.98
01-JAN-1881 45.06
01-JAN-1882 43.99
01-JAN-1883 44.02
01-JAN-1884 43.64
01-JAN-1885 44.57
01-JAN-1886 44.59
01-JAN-1887 45.08
01-JAN-1888 46.28
01-JAN-1889 45.93
01-JAN-1890 44.12
01-JAN-1891 44.43
01-JAN-1892 45.59
01-JAN-1893 44.68
01-JAN-1894 48.28
01-JAN-1895 45.41
01-JAN-1896 47.07
01-JAN-1897 46.45
01-JAN-1898 46.14
01-JAN-1899 45.25
01-JAN-1900 45.62
01-JAN-1901 46.93
01-JAN-1902 48.36
01-JAN-1903 49.54
01-JAN-1904 48.15
01-JAN-1905 49.92
01-JAN-1906 49.6
01-JAN-1907 50.57
01-JAN-1908 51.02
01-JAN-1909 51.67
01-JAN-1910 53.26
01-JAN-1911 51.23
01-JAN-1912 54.31
01-JAN-1913 53.36
01-JAN-1914 53.21
01-JAN-1915 51.21
01-JAN-1916 54.24
01-JAN-1917 54.16
01-JAN-1918 47.28
01-JAN-1919 54.31
01-JAN-1920 57.26
01-JAN-1921 58.09
01-JAN-1922 57.03
01-JAN-1923 59.31
01-JAN-1924 58.08
01-JAN-1925 58.43
01-JAN-1926 59.57
01-JAN-1927 58.96
01-JAN-1928 59.92
01-JAN-1929 57.63
01-JAN-1930 60.78
01-JAN-1931 60.01
01-JAN-1932 60.53
01-JAN-1933 60.58
01-JAN-1934 61.31
01-JAN-1935 61.96
01-JAN-1936 61.76
01-JAN-1937 61.8
01-JAN-1938 63.21
01-JAN-1939 63.61
01-JAN-1940 60.88
01-JAN-1941 61.35
01-JAN-1942 63.99
01-JAN-1943 64.01
01-JAN-1944 64.81
01-JAN-1945 65.75
01-JAN-1946 66.34
01-JAN-1947 66.31
01-JAN-1948 68.39
01-JAN-1949 68.11
01-JAN-1950 68.63
01-JAN-1951 68.24
01-JAN-1952 69.54
01-JAN-1953 69.8
01-JAN-1954 70.17
01-JAN-1955 70.14
01-JAN-1956 70.4
01-JAN-1957 70.53
01-JAN-1958 70.7
01-JAN-1959 70.82
01-JAN-1960 71.04
01-JAN-1961 70.79
01-JAN-1962 70.85
01-JAN-1963 70.76
01-JAN-1964 71.55
01-JAN-1965 71.52
01-JAN-1966 71.44
01-JAN-1967 72.07
01-JAN-1968 71.69
01-JAN-1969 71.66
01-JAN-1970 71.9
01-JAN-1971 72.23
01-JAN-1972 72
01-JAN-1973 72.19
01-JAN-1974 72.38
01-JAN-1975 72.65
01-JAN-1976 72.64
01-JAN-1977 73.12
01-JAN-1978 73.06
01-JAN-1979 73.16
01-JAN-1980 73.59
01-JAN-1981 73.92
01-JAN-1982 74.04
01-JAN-1983 74.29
01-JAN-1984 74.68
01-JAN-1985 74.53
01-JAN-1986 74.8
01-JAN-1987 75.15
01-JAN-1988 75.26
01-JAN-1989 75.4
01-JAN-1990 75.74
01-JAN-1991 75.91
01-JAN-1992 76.3
01-JAN-1993 76.17
01-JAN-1994 76.72
01-JAN-1995 76.62
01-JAN-1996 76.88
01-JAN-1997 77.14
01-JAN-1998 77.28
01-JAN-1999 77.38
01-JAN-2000 77.86
01-JAN-2001 78.14
01-JAN-2002 78.26
01-JAN-2003 78.35
01-JAN-2004 78.93
01-JAN-2005 79.13
01-JAN-2006 79.37
01-JAN-2007 79.56
01-JAN-2008 79.68
01-JAN-2009 80.18
01-JAN-2010 80.41
01-JAN-2011 80.8

230 rows selected.

RECORDED_YEAR	AGE
01-JAN-1543	33.94
01-JAN-1548	38.82
01-JAN-1553	39.59
01-JAN-1558	22.38
01-JAN-1563	36.66
01-JAN-1568	39.67
01-JAN-1573	41.06
01-JAN-1578	41.56
01-JAN-1583	42.7
01-JAN-1588	37.05
01-JAN-1593	38.05
01-JAN-1598	37.82
01-JAN-1603	38.53
01-JAN-1608	39.59
01-JAN-1613	36.79
01-JAN-1618	40.31
01-JAN-1623	33.39
01-JAN-1628	39.69
01-JAN-1633	39.72
01-JAN-1638	34.03
01-JAN-1643	36.32
01-JAN-1648	39.74
01-JAN-1653	39.14
01-JAN-1658	33.04
01-JAN-1663	33.27
01-JAN-1668	32.48
01-JAN-1673	37.41
01-JAN-1678	32.4
01-JAN-1683	31.27
01-JAN-1688	35.93
01-JAN-1693	36.35
01-JAN-1698	38.06
01-JAN-1703	38.47
01-JAN-1708	38.5
01-JAN-1713	36.89
01-JAN-1718	35.75
01-JAN-1723	35.49
01-JAN-1728	25.34
01-JAN-1733	36.34
01-JAN-1738	35.26
01-JAN-1743	34.27
01-JAN-1748	36.47
01-JAN-1753	39.77
01-JAN-1758	38.12
01-JAN-1763	35.37
01-JAN-1768	36.19
01-JAN-1773	39.09
01-JAN-1778	37.74
01-JAN-1783	35.81
01-JAN-1788	38.97
01-JAN-1793	37.92
01-JAN-1798	38.93
01-JAN-1803	40.02
01-JAN-1808	40.58
01-JAN-1813	41.25
01-JAN-1818	40.84
01-JAN-1823	40.47
01-JAN-1828	41.43
01-JAN-1833	40.89
01-JAN-1838	40.56
01-JAN-1842	41
01-JAN-1843	41.56
01-JAN-1844	41.24
01-JAN-1845	42.17
01-JAN-1846	40.15
01-JAN-1847	38.52
01-JAN-1848	39.89
01-JAN-1849	37.68
01-JAN-1850	42.77
01-JAN-1851	40.95
01-JAN-1852	40.41
01-JAN-1853	39.99
01-JAN-1854	39.48
01-JAN-1855	40.74
01-JAN-1856	42.47
01-JAN-1857	40.93
01-JAN-1858	39.55
01-JAN-1859	40.41
01-JAN-1860	41.95
01-JAN-1861	41.62
01-JAN-1862	42.13
01-JAN-1863	40.37
01-JAN-1864	39.59
01-JAN-1865	39.75
01-JAN-1866	40.09
01-JAN-1867	42
01-JAN-1868	41.7
01-JAN-1869	41.34
01-JAN-1870	40.61
01-JAN-1871	41.14
01-JAN-1872	42.72
01-JAN-1873	43.29
01-JAN-1874	42.11
01-JAN-1875	41.45
01-JAN-1876	42.67
01-JAN-1877	43.69
01-JAN-1878	42.04
01-JAN-1879	43.51
01-JAN-1880	42.98
01-JAN-1881	45.06
01-JAN-1882	43.99
01-JAN-1883	44.02
01-JAN-1884	43.64
01-JAN-1885	44.57
01-JAN-1886	44.59
01-JAN-1887	45.08
01-JAN-1888	46.28
01-JAN-1889	45.93
01-JAN-1890	44.12
01-JAN-1891	44.43
01-JAN-1892	45.59
01-JAN-1893	44.68
01-JAN-1894	48.28
01-JAN-1895	45.41
01-JAN-1896	47.07
01-JAN-1897	46.45
01-JAN-1898	46.14
01-JAN-1899	45.25
01-JAN-1900	45.62
01-JAN-1901	46.93
01-JAN-1902	48.36
01-JAN-1903	49.54
01-JAN-1904	48.15
01-JAN-1905	49.92
01-JAN-1906	49.6
01-JAN-1907	50.57
01-JAN-1908	51.02
01-JAN-1909	51.67
01-JAN-1910	53.26
01-JAN-1911	51.23
01-JAN-1912	54.31
01-JAN-1913	53.36
01-JAN-1914	53.21
01-JAN-1915	51.21
01-JAN-1916	54.24
01-JAN-1917	54.16
01-JAN-1918	47.28
01-JAN-1919	54.31
01-JAN-1920	57.26
01-JAN-1921	58.09
01-JAN-1922	57.03
01-JAN-1923	59.31
01-JAN-1924	58.08
01-JAN-1925	58.43
01-JAN-1926	59.57
01-JAN-1927	58.96
01-JAN-1928	59.92
01-JAN-1929	57.63
01-JAN-1930	60.78
01-JAN-1931	60.01
01-JAN-1932	60.53
01-JAN-1933	60.58
01-JAN-1934	61.31
01-JAN-1935	61.96
01-JAN-1936	61.76
01-JAN-1937	61.8
01-JAN-1938	63.21
01-JAN-1939	63.61
01-JAN-1940	60.88
01-JAN-1941	61.35
01-JAN-1942	63.99
01-JAN-1943	64.01
01-JAN-1944	64.81
01-JAN-1945	65.75
01-JAN-1946	66.34
01-JAN-1947	66.31
01-JAN-1948	68.39
01-JAN-1949	68.11
01-JAN-1950	68.63
01-JAN-1951	68.24
01-JAN-1952	69.54
01-JAN-1953	69.8
01-JAN-1954	70.17
01-JAN-1955	70.14
01-JAN-1956	70.4
01-JAN-1957	70.53
01-JAN-1958	70.7
01-JAN-1959	70.82
01-JAN-1960	71.04
01-JAN-1961	70.79
01-JAN-1962	70.85
01-JAN-1963	70.76
01-JAN-1964	71.55
01-JAN-1965	71.52
01-JAN-1966	71.44
01-JAN-1967	72.07
01-JAN-1968	71.69
01-JAN-1969	71.66
01-JAN-1970	71.9
01-JAN-1971	72.23
01-JAN-1972	72
01-JAN-1973	72.19
01-JAN-1974	72.38
01-JAN-1975	72.65
01-JAN-1976	72.64
01-JAN-1977	73.12
01-JAN-1978	73.06
01-JAN-1979	73.16
01-JAN-1980	73.59
01-JAN-1981	73.92
01-JAN-1982	74.04
01-JAN-1983	74.29
01-JAN-1984	74.68
01-JAN-1985	74.53
01-JAN-1986	74.8
01-JAN-1987	75.15
01-JAN-1988	75.26
01-JAN-1989	75.4
01-JAN-1990	75.74
01-JAN-1991	75.91
01-JAN-1992	76.3
01-JAN-1993	76.17
01-JAN-1994	76.72
01-JAN-1995	76.62
01-JAN-1996	76.88
01-JAN-1997	77.14
01-JAN-1998	77.28
01-JAN-1999	77.38
01-JAN-2000	77.86
01-JAN-2001	78.14
01-JAN-2002	78.26
01-JAN-2003	78.35
01-JAN-2004	78.93
01-JAN-2005	79.13
01-JAN-2006	79.37
01-JAN-2007	79.56
01-JAN-2008	79.68
01-JAN-2009	80.18
01-JAN-2010	80.41
01-JAN-2011	80.8

Statement 236

select  
  recorded_year, age,
  first_value(age) over
    ( order by recorded_year
      range between interval '5' year preceding 
            and interval '5' year following ) as first_val
from life_expectancy
order by 1

 
RECORDED_YEAR AGE FIRST_VAL
01-JAN-1543 33.94 33.94
01-JAN-1548 38.82 33.94
01-JAN-1553 39.59 38.82
01-JAN-1558 22.38 39.59
01-JAN-1563 36.66 22.38
01-JAN-1568 39.67 36.66
01-JAN-1573 41.06 39.67
01-JAN-1578 41.56 41.06
01-JAN-1583 42.7 41.56
01-JAN-1588 37.05 42.7
01-JAN-1593 38.05 37.05
01-JAN-1598 37.82 38.05
01-JAN-1603 38.53 37.82
01-JAN-1608 39.59 38.53
01-JAN-1613 36.79 39.59
01-JAN-1618 40.31 36.79
01-JAN-1623 33.39 40.31
01-JAN-1628 39.69 33.39
01-JAN-1633 39.72 39.69
01-JAN-1638 34.03 39.72
01-JAN-1643 36.32 34.03
01-JAN-1648 39.74 36.32
01-JAN-1653 39.14 39.74
01-JAN-1658 33.04 39.14
01-JAN-1663 33.27 33.04
01-JAN-1668 32.48 33.27
01-JAN-1673 37.41 32.48
01-JAN-1678 32.4 37.41
01-JAN-1683 31.27 32.4
01-JAN-1688 35.93 31.27
01-JAN-1693 36.35 35.93
01-JAN-1698 38.06 36.35
01-JAN-1703 38.47 38.06
01-JAN-1708 38.5 38.47
01-JAN-1713 36.89 38.5
01-JAN-1718 35.75 36.89
01-JAN-1723 35.49 35.75
01-JAN-1728 25.34 35.49
01-JAN-1733 36.34 25.34
01-JAN-1738 35.26 36.34
01-JAN-1743 34.27 35.26
01-JAN-1748 36.47 34.27
01-JAN-1753 39.77 36.47
01-JAN-1758 38.12 39.77
01-JAN-1763 35.37 38.12
01-JAN-1768 36.19 35.37
01-JAN-1773 39.09 36.19
01-JAN-1778 37.74 39.09
01-JAN-1783 35.81 37.74
01-JAN-1788 38.97 35.81
01-JAN-1793 37.92 38.97
01-JAN-1798 38.93 37.92
01-JAN-1803 40.02 38.93
01-JAN-1808 40.58 40.02
01-JAN-1813 41.25 40.58
01-JAN-1818 40.84 41.25
01-JAN-1823 40.47 40.84
01-JAN-1828 41.43 40.47
01-JAN-1833 40.89 41.43
01-JAN-1838 40.56 40.89
01-JAN-1842 41 40.56
01-JAN-1843 41.56 40.56
01-JAN-1844 41.24 41
01-JAN-1845 42.17 41
01-JAN-1846 40.15 41
01-JAN-1847 38.52 41
01-JAN-1848 39.89 41.56
01-JAN-1849 37.68 41.24
01-JAN-1850 42.77 42.17
01-JAN-1851 40.95 40.15
01-JAN-1852 40.41 38.52
01-JAN-1853 39.99 39.89
01-JAN-1854 39.48 37.68
01-JAN-1855 40.74 42.77
01-JAN-1856 42.47 40.95
01-JAN-1857 40.93 40.41
01-JAN-1858 39.55 39.99
01-JAN-1859 40.41 39.48
01-JAN-1860 41.95 40.74
01-JAN-1861 41.62 42.47
01-JAN-1862 42.13 40.93
01-JAN-1863 40.37 39.55
01-JAN-1864 39.59 40.41
01-JAN-1865 39.75 41.95
01-JAN-1866 40.09 41.62
01-JAN-1867 42 42.13
01-JAN-1868 41.7 40.37
01-JAN-1869 41.34 39.59
01-JAN-1870 40.61 39.75
01-JAN-1871 41.14 40.09
01-JAN-1872 42.72 42
01-JAN-1873 43.29 41.7
01-JAN-1874 42.11 41.34
01-JAN-1875 41.45 40.61
01-JAN-1876 42.67 41.14
01-JAN-1877 43.69 42.72
01-JAN-1878 42.04 43.29
01-JAN-1879 43.51 42.11
01-JAN-1880 42.98 41.45
01-JAN-1881 45.06 42.67
01-JAN-1882 43.99 43.69
01-JAN-1883 44.02 42.04
01-JAN-1884 43.64 43.51
01-JAN-1885 44.57 42.98
01-JAN-1886 44.59 45.06
01-JAN-1887 45.08 43.99
01-JAN-1888 46.28 44.02
01-JAN-1889 45.93 43.64
01-JAN-1890 44.12 44.57
01-JAN-1891 44.43 44.59
01-JAN-1892 45.59 45.08
01-JAN-1893 44.68 46.28
01-JAN-1894 48.28 45.93
01-JAN-1895 45.41 44.12
01-JAN-1896 47.07 44.43
01-JAN-1897 46.45 45.59
01-JAN-1898 46.14 44.68
01-JAN-1899 45.25 48.28
01-JAN-1900 45.62 45.41
01-JAN-1901 46.93 47.07
01-JAN-1902 48.36 46.45
01-JAN-1903 49.54 46.14
01-JAN-1904 48.15 45.25
01-JAN-1905 49.92 45.62
01-JAN-1906 49.6 46.93
01-JAN-1907 50.57 48.36
01-JAN-1908 51.02 49.54
01-JAN-1909 51.67 48.15
01-JAN-1910 53.26 49.92
01-JAN-1911 51.23 49.6
01-JAN-1912 54.31 50.57
01-JAN-1913 53.36 51.02
01-JAN-1914 53.21 51.67
01-JAN-1915 51.21 53.26
01-JAN-1916 54.24 51.23
01-JAN-1917 54.16 54.31
01-JAN-1918 47.28 53.36
01-JAN-1919 54.31 53.21
01-JAN-1920 57.26 51.21
01-JAN-1921 58.09 54.24
01-JAN-1922 57.03 54.16
01-JAN-1923 59.31 47.28
01-JAN-1924 58.08 54.31
01-JAN-1925 58.43 57.26
01-JAN-1926 59.57 58.09
01-JAN-1927 58.96 57.03
01-JAN-1928 59.92 59.31
01-JAN-1929 57.63 58.08
01-JAN-1930 60.78 58.43
01-JAN-1931 60.01 59.57
01-JAN-1932 60.53 58.96
01-JAN-1933 60.58 59.92
01-JAN-1934 61.31 57.63
01-JAN-1935 61.96 60.78
01-JAN-1936 61.76 60.01
01-JAN-1937 61.8 60.53
01-JAN-1938 63.21 60.58
01-JAN-1939 63.61 61.31
01-JAN-1940 60.88 61.96
01-JAN-1941 61.35 61.76
01-JAN-1942 63.99 61.8
01-JAN-1943 64.01 63.21
01-JAN-1944 64.81 63.61
01-JAN-1945 65.75 60.88
01-JAN-1946 66.34 61.35
01-JAN-1947 66.31 63.99
01-JAN-1948 68.39 64.01
01-JAN-1949 68.11 64.81
01-JAN-1950 68.63 65.75
01-JAN-1951 68.24 66.34
01-JAN-1952 69.54 66.31
01-JAN-1953 69.8 68.39
01-JAN-1954 70.17 68.11
01-JAN-1955 70.14 68.63
01-JAN-1956 70.4 68.24
01-JAN-1957 70.53 69.54
01-JAN-1958 70.7 69.8
01-JAN-1959 70.82 70.17
01-JAN-1960 71.04 70.14
01-JAN-1961 70.79 70.4
01-JAN-1962 70.85 70.53
01-JAN-1963 70.76 70.7
01-JAN-1964 71.55 70.82
01-JAN-1965 71.52 71.04
01-JAN-1966 71.44 70.79
01-JAN-1967 72.07 70.85
01-JAN-1968 71.69 70.76
01-JAN-1969 71.66 71.55
01-JAN-1970 71.9 71.52
01-JAN-1971 72.23 71.44
01-JAN-1972 72 72.07
01-JAN-1973 72.19 71.69
01-JAN-1974 72.38 71.66
01-JAN-1975 72.65 71.9
01-JAN-1976 72.64 72.23
01-JAN-1977 73.12 72
01-JAN-1978 73.06 72.19
01-JAN-1979 73.16 72.38
01-JAN-1980 73.59 72.65
01-JAN-1981 73.92 72.64
01-JAN-1982 74.04 73.12
01-JAN-1983 74.29 73.06
01-JAN-1984 74.68 73.16
01-JAN-1985 74.53 73.59
01-JAN-1986 74.8 73.92
01-JAN-1987 75.15 74.04
01-JAN-1988 75.26 74.29
01-JAN-1989 75.4 74.68
01-JAN-1990 75.74 74.53
01-JAN-1991 75.91 74.8
01-JAN-1992 76.3 75.15
01-JAN-1993 76.17 75.26
01-JAN-1994 76.72 75.4
01-JAN-1995 76.62 75.74
01-JAN-1996 76.88 75.91
01-JAN-1997 77.14 76.3
01-JAN-1998 77.28 76.17
01-JAN-1999 77.38 76.72
01-JAN-2000 77.86 76.62
01-JAN-2001 78.14 76.88
01-JAN-2002 78.26 77.14
01-JAN-2003 78.35 77.28
01-JAN-2004 78.93 77.38
01-JAN-2005 79.13 77.86
01-JAN-2006 79.37 78.14
01-JAN-2007 79.56 78.26
01-JAN-2008 79.68 78.35
01-JAN-2009 80.18 78.93
01-JAN-2010 80.41 79.13
01-JAN-2011 80.8 79.37

230 rows selected.

RECORDED_YEAR	AGE	FIRST_VAL
01-JAN-1543	33.94	33.94
01-JAN-1548	38.82	33.94
01-JAN-1553	39.59	38.82
01-JAN-1558	22.38	39.59
01-JAN-1563	36.66	22.38
01-JAN-1568	39.67	36.66
01-JAN-1573	41.06	39.67
01-JAN-1578	41.56	41.06
01-JAN-1583	42.7	41.56
01-JAN-1588	37.05	42.7
01-JAN-1593	38.05	37.05
01-JAN-1598	37.82	38.05
01-JAN-1603	38.53	37.82
01-JAN-1608	39.59	38.53
01-JAN-1613	36.79	39.59
01-JAN-1618	40.31	36.79
01-JAN-1623	33.39	40.31
01-JAN-1628	39.69	33.39
01-JAN-1633	39.72	39.69
01-JAN-1638	34.03	39.72
01-JAN-1643	36.32	34.03
01-JAN-1648	39.74	36.32
01-JAN-1653	39.14	39.74
01-JAN-1658	33.04	39.14
01-JAN-1663	33.27	33.04
01-JAN-1668	32.48	33.27
01-JAN-1673	37.41	32.48
01-JAN-1678	32.4	37.41
01-JAN-1683	31.27	32.4
01-JAN-1688	35.93	31.27
01-JAN-1693	36.35	35.93
01-JAN-1698	38.06	36.35
01-JAN-1703	38.47	38.06
01-JAN-1708	38.5	38.47
01-JAN-1713	36.89	38.5
01-JAN-1718	35.75	36.89
01-JAN-1723	35.49	35.75
01-JAN-1728	25.34	35.49
01-JAN-1733	36.34	25.34
01-JAN-1738	35.26	36.34
01-JAN-1743	34.27	35.26
01-JAN-1748	36.47	34.27
01-JAN-1753	39.77	36.47
01-JAN-1758	38.12	39.77
01-JAN-1763	35.37	38.12
01-JAN-1768	36.19	35.37
01-JAN-1773	39.09	36.19
01-JAN-1778	37.74	39.09
01-JAN-1783	35.81	37.74
01-JAN-1788	38.97	35.81
01-JAN-1793	37.92	38.97
01-JAN-1798	38.93	37.92
01-JAN-1803	40.02	38.93
01-JAN-1808	40.58	40.02
01-JAN-1813	41.25	40.58
01-JAN-1818	40.84	41.25
01-JAN-1823	40.47	40.84
01-JAN-1828	41.43	40.47
01-JAN-1833	40.89	41.43
01-JAN-1838	40.56	40.89
01-JAN-1842	41	40.56
01-JAN-1843	41.56	40.56
01-JAN-1844	41.24	41
01-JAN-1845	42.17	41
01-JAN-1846	40.15	41
01-JAN-1847	38.52	41
01-JAN-1848	39.89	41.56
01-JAN-1849	37.68	41.24
01-JAN-1850	42.77	42.17
01-JAN-1851	40.95	40.15
01-JAN-1852	40.41	38.52
01-JAN-1853	39.99	39.89
01-JAN-1854	39.48	37.68
01-JAN-1855	40.74	42.77
01-JAN-1856	42.47	40.95
01-JAN-1857	40.93	40.41
01-JAN-1858	39.55	39.99
01-JAN-1859	40.41	39.48
01-JAN-1860	41.95	40.74
01-JAN-1861	41.62	42.47
01-JAN-1862	42.13	40.93
01-JAN-1863	40.37	39.55
01-JAN-1864	39.59	40.41
01-JAN-1865	39.75	41.95
01-JAN-1866	40.09	41.62
01-JAN-1867	42	42.13
01-JAN-1868	41.7	40.37
01-JAN-1869	41.34	39.59
01-JAN-1870	40.61	39.75
01-JAN-1871	41.14	40.09
01-JAN-1872	42.72	42
01-JAN-1873	43.29	41.7
01-JAN-1874	42.11	41.34
01-JAN-1875	41.45	40.61
01-JAN-1876	42.67	41.14
01-JAN-1877	43.69	42.72
01-JAN-1878	42.04	43.29
01-JAN-1879	43.51	42.11
01-JAN-1880	42.98	41.45
01-JAN-1881	45.06	42.67
01-JAN-1882	43.99	43.69
01-JAN-1883	44.02	42.04
01-JAN-1884	43.64	43.51
01-JAN-1885	44.57	42.98
01-JAN-1886	44.59	45.06
01-JAN-1887	45.08	43.99
01-JAN-1888	46.28	44.02
01-JAN-1889	45.93	43.64
01-JAN-1890	44.12	44.57
01-JAN-1891	44.43	44.59
01-JAN-1892	45.59	45.08
01-JAN-1893	44.68	46.28
01-JAN-1894	48.28	45.93
01-JAN-1895	45.41	44.12
01-JAN-1896	47.07	44.43
01-JAN-1897	46.45	45.59
01-JAN-1898	46.14	44.68
01-JAN-1899	45.25	48.28
01-JAN-1900	45.62	45.41
01-JAN-1901	46.93	47.07
01-JAN-1902	48.36	46.45
01-JAN-1903	49.54	46.14
01-JAN-1904	48.15	45.25
01-JAN-1905	49.92	45.62
01-JAN-1906	49.6	46.93
01-JAN-1907	50.57	48.36
01-JAN-1908	51.02	49.54
01-JAN-1909	51.67	48.15
01-JAN-1910	53.26	49.92
01-JAN-1911	51.23	49.6
01-JAN-1912	54.31	50.57
01-JAN-1913	53.36	51.02
01-JAN-1914	53.21	51.67
01-JAN-1915	51.21	53.26
01-JAN-1916	54.24	51.23
01-JAN-1917	54.16	54.31
01-JAN-1918	47.28	53.36
01-JAN-1919	54.31	53.21
01-JAN-1920	57.26	51.21
01-JAN-1921	58.09	54.24
01-JAN-1922	57.03	54.16
01-JAN-1923	59.31	47.28
01-JAN-1924	58.08	54.31
01-JAN-1925	58.43	57.26
01-JAN-1926	59.57	58.09
01-JAN-1927	58.96	57.03
01-JAN-1928	59.92	59.31
01-JAN-1929	57.63	58.08
01-JAN-1930	60.78	58.43
01-JAN-1931	60.01	59.57
01-JAN-1932	60.53	58.96
01-JAN-1933	60.58	59.92
01-JAN-1934	61.31	57.63
01-JAN-1935	61.96	60.78
01-JAN-1936	61.76	60.01
01-JAN-1937	61.8	60.53
01-JAN-1938	63.21	60.58
01-JAN-1939	63.61	61.31
01-JAN-1940	60.88	61.96
01-JAN-1941	61.35	61.76
01-JAN-1942	63.99	61.8
01-JAN-1943	64.01	63.21
01-JAN-1944	64.81	63.61
01-JAN-1945	65.75	60.88
01-JAN-1946	66.34	61.35
01-JAN-1947	66.31	63.99
01-JAN-1948	68.39	64.01
01-JAN-1949	68.11	64.81
01-JAN-1950	68.63	65.75
01-JAN-1951	68.24	66.34
01-JAN-1952	69.54	66.31
01-JAN-1953	69.8	68.39
01-JAN-1954	70.17	68.11
01-JAN-1955	70.14	68.63
01-JAN-1956	70.4	68.24
01-JAN-1957	70.53	69.54
01-JAN-1958	70.7	69.8
01-JAN-1959	70.82	70.17
01-JAN-1960	71.04	70.14
01-JAN-1961	70.79	70.4
01-JAN-1962	70.85	70.53
01-JAN-1963	70.76	70.7
01-JAN-1964	71.55	70.82
01-JAN-1965	71.52	71.04
01-JAN-1966	71.44	70.79
01-JAN-1967	72.07	70.85
01-JAN-1968	71.69	70.76
01-JAN-1969	71.66	71.55
01-JAN-1970	71.9	71.52
01-JAN-1971	72.23	71.44
01-JAN-1972	72	72.07
01-JAN-1973	72.19	71.69
01-JAN-1974	72.38	71.66
01-JAN-1975	72.65	71.9
01-JAN-1976	72.64	72.23
01-JAN-1977	73.12	72
01-JAN-1978	73.06	72.19
01-JAN-1979	73.16	72.38
01-JAN-1980	73.59	72.65
01-JAN-1981	73.92	72.64
01-JAN-1982	74.04	73.12
01-JAN-1983	74.29	73.06
01-JAN-1984	74.68	73.16
01-JAN-1985	74.53	73.59
01-JAN-1986	74.8	73.92
01-JAN-1987	75.15	74.04
01-JAN-1988	75.26	74.29
01-JAN-1989	75.4	74.68
01-JAN-1990	75.74	74.53
01-JAN-1991	75.91	74.8
01-JAN-1992	76.3	75.15
01-JAN-1993	76.17	75.26
01-JAN-1994	76.72	75.4
01-JAN-1995	76.62	75.74
01-JAN-1996	76.88	75.91
01-JAN-1997	77.14	76.3
01-JAN-1998	77.28	76.17
01-JAN-1999	77.38	76.72
01-JAN-2000	77.86	76.62
01-JAN-2001	78.14	76.88
01-JAN-2002	78.26	77.14
01-JAN-2003	78.35	77.28
01-JAN-2004	78.93	77.38
01-JAN-2005	79.13	77.86
01-JAN-2006	79.37	78.14
01-JAN-2007	79.56	78.26
01-JAN-2008	79.68	78.35
01-JAN-2009	80.18	78.93
01-JAN-2010	80.41	79.13
01-JAN-2011	80.8	79.37

Statement 237

select  
  recorded_year, age,
  first_value(age) over
    ( order by recorded_year
      range between interval '5' year preceding 
            and interval '5' year following ) as first_val,
  last_value(age) over
    ( order by recorded_year
      range between interval '5' year preceding 
            and interval '5' year following ) as last_val
from life_expectancy
order by 1

 
RECORDED_YEAR AGE FIRST_VAL LAST_VAL
01-JAN-1543 33.94 33.94 38.82
01-JAN-1548 38.82 33.94 39.59
01-JAN-1553 39.59 38.82 22.38
01-JAN-1558 22.38 39.59 36.66
01-JAN-1563 36.66 22.38 39.67
01-JAN-1568 39.67 36.66 41.06
01-JAN-1573 41.06 39.67 41.56
01-JAN-1578 41.56 41.06 42.7
01-JAN-1583 42.7 41.56 37.05
01-JAN-1588 37.05 42.7 38.05
01-JAN-1593 38.05 37.05 37.82
01-JAN-1598 37.82 38.05 38.53
01-JAN-1603 38.53 37.82 39.59
01-JAN-1608 39.59 38.53 36.79
01-JAN-1613 36.79 39.59 40.31
01-JAN-1618 40.31 36.79 33.39
01-JAN-1623 33.39 40.31 39.69
01-JAN-1628 39.69 33.39 39.72
01-JAN-1633 39.72 39.69 34.03
01-JAN-1638 34.03 39.72 36.32
01-JAN-1643 36.32 34.03 39.74
01-JAN-1648 39.74 36.32 39.14
01-JAN-1653 39.14 39.74 33.04
01-JAN-1658 33.04 39.14 33.27
01-JAN-1663 33.27 33.04 32.48
01-JAN-1668 32.48 33.27 37.41
01-JAN-1673 37.41 32.48 32.4
01-JAN-1678 32.4 37.41 31.27
01-JAN-1683 31.27 32.4 35.93
01-JAN-1688 35.93 31.27 36.35
01-JAN-1693 36.35 35.93 38.06
01-JAN-1698 38.06 36.35 38.47
01-JAN-1703 38.47 38.06 38.5
01-JAN-1708 38.5 38.47 36.89
01-JAN-1713 36.89 38.5 35.75
01-JAN-1718 35.75 36.89 35.49
01-JAN-1723 35.49 35.75 25.34
01-JAN-1728 25.34 35.49 36.34
01-JAN-1733 36.34 25.34 35.26
01-JAN-1738 35.26 36.34 34.27
01-JAN-1743 34.27 35.26 36.47
01-JAN-1748 36.47 34.27 39.77
01-JAN-1753 39.77 36.47 38.12
01-JAN-1758 38.12 39.77 35.37
01-JAN-1763 35.37 38.12 36.19
01-JAN-1768 36.19 35.37 39.09
01-JAN-1773 39.09 36.19 37.74
01-JAN-1778 37.74 39.09 35.81
01-JAN-1783 35.81 37.74 38.97
01-JAN-1788 38.97 35.81 37.92
01-JAN-1793 37.92 38.97 38.93
01-JAN-1798 38.93 37.92 40.02
01-JAN-1803 40.02 38.93 40.58
01-JAN-1808 40.58 40.02 41.25
01-JAN-1813 41.25 40.58 40.84
01-JAN-1818 40.84 41.25 40.47
01-JAN-1823 40.47 40.84 41.43
01-JAN-1828 41.43 40.47 40.89
01-JAN-1833 40.89 41.43 40.56
01-JAN-1838 40.56 40.89 41.56
01-JAN-1842 41 40.56 38.52
01-JAN-1843 41.56 40.56 39.89
01-JAN-1844 41.24 41 37.68
01-JAN-1845 42.17 41 42.77
01-JAN-1846 40.15 41 40.95
01-JAN-1847 38.52 41 40.41
01-JAN-1848 39.89 41.56 39.99
01-JAN-1849 37.68 41.24 39.48
01-JAN-1850 42.77 42.17 40.74
01-JAN-1851 40.95 40.15 42.47
01-JAN-1852 40.41 38.52 40.93
01-JAN-1853 39.99 39.89 39.55
01-JAN-1854 39.48 37.68 40.41
01-JAN-1855 40.74 42.77 41.95
01-JAN-1856 42.47 40.95 41.62
01-JAN-1857 40.93 40.41 42.13
01-JAN-1858 39.55 39.99 40.37
01-JAN-1859 40.41 39.48 39.59
01-JAN-1860 41.95 40.74 39.75
01-JAN-1861 41.62 42.47 40.09
01-JAN-1862 42.13 40.93 42
01-JAN-1863 40.37 39.55 41.7
01-JAN-1864 39.59 40.41 41.34
01-JAN-1865 39.75 41.95 40.61
01-JAN-1866 40.09 41.62 41.14
01-JAN-1867 42 42.13 42.72
01-JAN-1868 41.7 40.37 43.29
01-JAN-1869 41.34 39.59 42.11
01-JAN-1870 40.61 39.75 41.45
01-JAN-1871 41.14 40.09 42.67
01-JAN-1872 42.72 42 43.69
01-JAN-1873 43.29 41.7 42.04
01-JAN-1874 42.11 41.34 43.51
01-JAN-1875 41.45 40.61 42.98
01-JAN-1876 42.67 41.14 45.06
01-JAN-1877 43.69 42.72 43.99
01-JAN-1878 42.04 43.29 44.02
01-JAN-1879 43.51 42.11 43.64
01-JAN-1880 42.98 41.45 44.57
01-JAN-1881 45.06 42.67 44.59
01-JAN-1882 43.99 43.69 45.08
01-JAN-1883 44.02 42.04 46.28
01-JAN-1884 43.64 43.51 45.93
01-JAN-1885 44.57 42.98 44.12
01-JAN-1886 44.59 45.06 44.43
01-JAN-1887 45.08 43.99 45.59
01-JAN-1888 46.28 44.02 44.68
01-JAN-1889 45.93 43.64 48.28
01-JAN-1890 44.12 44.57 45.41
01-JAN-1891 44.43 44.59 47.07
01-JAN-1892 45.59 45.08 46.45
01-JAN-1893 44.68 46.28 46.14
01-JAN-1894 48.28 45.93 45.25
01-JAN-1895 45.41 44.12 45.62
01-JAN-1896 47.07 44.43 46.93
01-JAN-1897 46.45 45.59 48.36
01-JAN-1898 46.14 44.68 49.54
01-JAN-1899 45.25 48.28 48.15
01-JAN-1900 45.62 45.41 49.92
01-JAN-1901 46.93 47.07 49.6
01-JAN-1902 48.36 46.45 50.57
01-JAN-1903 49.54 46.14 51.02
01-JAN-1904 48.15 45.25 51.67
01-JAN-1905 49.92 45.62 53.26
01-JAN-1906 49.6 46.93 51.23
01-JAN-1907 50.57 48.36 54.31
01-JAN-1908 51.02 49.54 53.36
01-JAN-1909 51.67 48.15 53.21
01-JAN-1910 53.26 49.92 51.21
01-JAN-1911 51.23 49.6 54.24
01-JAN-1912 54.31 50.57 54.16
01-JAN-1913 53.36 51.02 47.28
01-JAN-1914 53.21 51.67 54.31
01-JAN-1915 51.21 53.26 57.26
01-JAN-1916 54.24 51.23 58.09
01-JAN-1917 54.16 54.31 57.03
01-JAN-1918 47.28 53.36 59.31
01-JAN-1919 54.31 53.21 58.08
01-JAN-1920 57.26 51.21 58.43
01-JAN-1921 58.09 54.24 59.57
01-JAN-1922 57.03 54.16 58.96
01-JAN-1923 59.31 47.28 59.92
01-JAN-1924 58.08 54.31 57.63
01-JAN-1925 58.43 57.26 60.78
01-JAN-1926 59.57 58.09 60.01
01-JAN-1927 58.96 57.03 60.53
01-JAN-1928 59.92 59.31 60.58
01-JAN-1929 57.63 58.08 61.31
01-JAN-1930 60.78 58.43 61.96
01-JAN-1931 60.01 59.57 61.76
01-JAN-1932 60.53 58.96 61.8
01-JAN-1933 60.58 59.92 63.21
01-JAN-1934 61.31 57.63 63.61
01-JAN-1935 61.96 60.78 60.88
01-JAN-1936 61.76 60.01 61.35
01-JAN-1937 61.8 60.53 63.99
01-JAN-1938 63.21 60.58 64.01
01-JAN-1939 63.61 61.31 64.81
01-JAN-1940 60.88 61.96 65.75
01-JAN-1941 61.35 61.76 66.34
01-JAN-1942 63.99 61.8 66.31
01-JAN-1943 64.01 63.21 68.39
01-JAN-1944 64.81 63.61 68.11
01-JAN-1945 65.75 60.88 68.63
01-JAN-1946 66.34 61.35 68.24
01-JAN-1947 66.31 63.99 69.54
01-JAN-1948 68.39 64.01 69.8
01-JAN-1949 68.11 64.81 70.17
01-JAN-1950 68.63 65.75 70.14
01-JAN-1951 68.24 66.34 70.4
01-JAN-1952 69.54 66.31 70.53
01-JAN-1953 69.8 68.39 70.7
01-JAN-1954 70.17 68.11 70.82
01-JAN-1955 70.14 68.63 71.04
01-JAN-1956 70.4 68.24 70.79
01-JAN-1957 70.53 69.54 70.85
01-JAN-1958 70.7 69.8 70.76
01-JAN-1959 70.82 70.17 71.55
01-JAN-1960 71.04 70.14 71.52
01-JAN-1961 70.79 70.4 71.44
01-JAN-1962 70.85 70.53 72.07
01-JAN-1963 70.76 70.7 71.69
01-JAN-1964 71.55 70.82 71.66
01-JAN-1965 71.52 71.04 71.9
01-JAN-1966 71.44 70.79 72.23
01-JAN-1967 72.07 70.85 72
01-JAN-1968 71.69 70.76 72.19
01-JAN-1969 71.66 71.55 72.38
01-JAN-1970 71.9 71.52 72.65
01-JAN-1971 72.23 71.44 72.64
01-JAN-1972 72 72.07 73.12
01-JAN-1973 72.19 71.69 73.06
01-JAN-1974 72.38 71.66 73.16
01-JAN-1975 72.65 71.9 73.59
01-JAN-1976 72.64 72.23 73.92
01-JAN-1977 73.12 72 74.04
01-JAN-1978 73.06 72.19 74.29
01-JAN-1979 73.16 72.38 74.68
01-JAN-1980 73.59 72.65 74.53
01-JAN-1981 73.92 72.64 74.8
01-JAN-1982 74.04 73.12 75.15
01-JAN-1983 74.29 73.06 75.26
01-JAN-1984 74.68 73.16 75.4
01-JAN-1985 74.53 73.59 75.74
01-JAN-1986 74.8 73.92 75.91
01-JAN-1987 75.15 74.04 76.3
01-JAN-1988 75.26 74.29 76.17
01-JAN-1989 75.4 74.68 76.72
01-JAN-1990 75.74 74.53 76.62
01-JAN-1991 75.91 74.8 76.88
01-JAN-1992 76.3 75.15 77.14
01-JAN-1993 76.17 75.26 77.28
01-JAN-1994 76.72 75.4 77.38
01-JAN-1995 76.62 75.74 77.86
01-JAN-1996 76.88 75.91 78.14
01-JAN-1997 77.14 76.3 78.26
01-JAN-1998 77.28 76.17 78.35
01-JAN-1999 77.38 76.72 78.93
01-JAN-2000 77.86 76.62 79.13
01-JAN-2001 78.14 76.88 79.37
01-JAN-2002 78.26 77.14 79.56
01-JAN-2003 78.35 77.28 79.68
01-JAN-2004 78.93 77.38 80.18
01-JAN-2005 79.13 77.86 80.41
01-JAN-2006 79.37 78.14 80.8
01-JAN-2007 79.56 78.26 80.8
01-JAN-2008 79.68 78.35 80.8
01-JAN-2009 80.18 78.93 80.8
01-JAN-2010 80.41 79.13 80.8
01-JAN-2011 80.8 79.37 80.8

230 rows selected.

RECORDED_YEAR	AGE	FIRST_VAL	LAST_VAL
01-JAN-1543	33.94	33.94	38.82
01-JAN-1548	38.82	33.94	39.59
01-JAN-1553	39.59	38.82	22.38
01-JAN-1558	22.38	39.59	36.66
01-JAN-1563	36.66	22.38	39.67
01-JAN-1568	39.67	36.66	41.06
01-JAN-1573	41.06	39.67	41.56
01-JAN-1578	41.56	41.06	42.7
01-JAN-1583	42.7	41.56	37.05
01-JAN-1588	37.05	42.7	38.05
01-JAN-1593	38.05	37.05	37.82
01-JAN-1598	37.82	38.05	38.53
01-JAN-1603	38.53	37.82	39.59
01-JAN-1608	39.59	38.53	36.79
01-JAN-1613	36.79	39.59	40.31
01-JAN-1618	40.31	36.79	33.39
01-JAN-1623	33.39	40.31	39.69
01-JAN-1628	39.69	33.39	39.72
01-JAN-1633	39.72	39.69	34.03
01-JAN-1638	34.03	39.72	36.32
01-JAN-1643	36.32	34.03	39.74
01-JAN-1648	39.74	36.32	39.14
01-JAN-1653	39.14	39.74	33.04
01-JAN-1658	33.04	39.14	33.27
01-JAN-1663	33.27	33.04	32.48
01-JAN-1668	32.48	33.27	37.41
01-JAN-1673	37.41	32.48	32.4
01-JAN-1678	32.4	37.41	31.27
01-JAN-1683	31.27	32.4	35.93
01-JAN-1688	35.93	31.27	36.35
01-JAN-1693	36.35	35.93	38.06
01-JAN-1698	38.06	36.35	38.47
01-JAN-1703	38.47	38.06	38.5
01-JAN-1708	38.5	38.47	36.89
01-JAN-1713	36.89	38.5	35.75
01-JAN-1718	35.75	36.89	35.49
01-JAN-1723	35.49	35.75	25.34
01-JAN-1728	25.34	35.49	36.34
01-JAN-1733	36.34	25.34	35.26
01-JAN-1738	35.26	36.34	34.27
01-JAN-1743	34.27	35.26	36.47
01-JAN-1748	36.47	34.27	39.77
01-JAN-1753	39.77	36.47	38.12
01-JAN-1758	38.12	39.77	35.37
01-JAN-1763	35.37	38.12	36.19
01-JAN-1768	36.19	35.37	39.09
01-JAN-1773	39.09	36.19	37.74
01-JAN-1778	37.74	39.09	35.81
01-JAN-1783	35.81	37.74	38.97
01-JAN-1788	38.97	35.81	37.92
01-JAN-1793	37.92	38.97	38.93
01-JAN-1798	38.93	37.92	40.02
01-JAN-1803	40.02	38.93	40.58
01-JAN-1808	40.58	40.02	41.25
01-JAN-1813	41.25	40.58	40.84
01-JAN-1818	40.84	41.25	40.47
01-JAN-1823	40.47	40.84	41.43
01-JAN-1828	41.43	40.47	40.89
01-JAN-1833	40.89	41.43	40.56
01-JAN-1838	40.56	40.89	41.56
01-JAN-1842	41	40.56	38.52
01-JAN-1843	41.56	40.56	39.89
01-JAN-1844	41.24	41	37.68
01-JAN-1845	42.17	41	42.77
01-JAN-1846	40.15	41	40.95
01-JAN-1847	38.52	41	40.41
01-JAN-1848	39.89	41.56	39.99
01-JAN-1849	37.68	41.24	39.48
01-JAN-1850	42.77	42.17	40.74
01-JAN-1851	40.95	40.15	42.47
01-JAN-1852	40.41	38.52	40.93
01-JAN-1853	39.99	39.89	39.55
01-JAN-1854	39.48	37.68	40.41
01-JAN-1855	40.74	42.77	41.95
01-JAN-1856	42.47	40.95	41.62
01-JAN-1857	40.93	40.41	42.13
01-JAN-1858	39.55	39.99	40.37
01-JAN-1859	40.41	39.48	39.59
01-JAN-1860	41.95	40.74	39.75
01-JAN-1861	41.62	42.47	40.09
01-JAN-1862	42.13	40.93	42
01-JAN-1863	40.37	39.55	41.7
01-JAN-1864	39.59	40.41	41.34
01-JAN-1865	39.75	41.95	40.61
01-JAN-1866	40.09	41.62	41.14
01-JAN-1867	42	42.13	42.72
01-JAN-1868	41.7	40.37	43.29
01-JAN-1869	41.34	39.59	42.11
01-JAN-1870	40.61	39.75	41.45
01-JAN-1871	41.14	40.09	42.67
01-JAN-1872	42.72	42	43.69
01-JAN-1873	43.29	41.7	42.04
01-JAN-1874	42.11	41.34	43.51
01-JAN-1875	41.45	40.61	42.98
01-JAN-1876	42.67	41.14	45.06
01-JAN-1877	43.69	42.72	43.99
01-JAN-1878	42.04	43.29	44.02
01-JAN-1879	43.51	42.11	43.64
01-JAN-1880	42.98	41.45	44.57
01-JAN-1881	45.06	42.67	44.59
01-JAN-1882	43.99	43.69	45.08
01-JAN-1883	44.02	42.04	46.28
01-JAN-1884	43.64	43.51	45.93
01-JAN-1885	44.57	42.98	44.12
01-JAN-1886	44.59	45.06	44.43
01-JAN-1887	45.08	43.99	45.59
01-JAN-1888	46.28	44.02	44.68
01-JAN-1889	45.93	43.64	48.28
01-JAN-1890	44.12	44.57	45.41
01-JAN-1891	44.43	44.59	47.07
01-JAN-1892	45.59	45.08	46.45
01-JAN-1893	44.68	46.28	46.14
01-JAN-1894	48.28	45.93	45.25
01-JAN-1895	45.41	44.12	45.62
01-JAN-1896	47.07	44.43	46.93
01-JAN-1897	46.45	45.59	48.36
01-JAN-1898	46.14	44.68	49.54
01-JAN-1899	45.25	48.28	48.15
01-JAN-1900	45.62	45.41	49.92
01-JAN-1901	46.93	47.07	49.6
01-JAN-1902	48.36	46.45	50.57
01-JAN-1903	49.54	46.14	51.02
01-JAN-1904	48.15	45.25	51.67
01-JAN-1905	49.92	45.62	53.26
01-JAN-1906	49.6	46.93	51.23
01-JAN-1907	50.57	48.36	54.31
01-JAN-1908	51.02	49.54	53.36
01-JAN-1909	51.67	48.15	53.21
01-JAN-1910	53.26	49.92	51.21
01-JAN-1911	51.23	49.6	54.24
01-JAN-1912	54.31	50.57	54.16
01-JAN-1913	53.36	51.02	47.28
01-JAN-1914	53.21	51.67	54.31
01-JAN-1915	51.21	53.26	57.26
01-JAN-1916	54.24	51.23	58.09
01-JAN-1917	54.16	54.31	57.03
01-JAN-1918	47.28	53.36	59.31
01-JAN-1919	54.31	53.21	58.08
01-JAN-1920	57.26	51.21	58.43
01-JAN-1921	58.09	54.24	59.57
01-JAN-1922	57.03	54.16	58.96
01-JAN-1923	59.31	47.28	59.92
01-JAN-1924	58.08	54.31	57.63
01-JAN-1925	58.43	57.26	60.78
01-JAN-1926	59.57	58.09	60.01
01-JAN-1927	58.96	57.03	60.53
01-JAN-1928	59.92	59.31	60.58
01-JAN-1929	57.63	58.08	61.31
01-JAN-1930	60.78	58.43	61.96
01-JAN-1931	60.01	59.57	61.76
01-JAN-1932	60.53	58.96	61.8
01-JAN-1933	60.58	59.92	63.21
01-JAN-1934	61.31	57.63	63.61
01-JAN-1935	61.96	60.78	60.88
01-JAN-1936	61.76	60.01	61.35
01-JAN-1937	61.8	60.53	63.99
01-JAN-1938	63.21	60.58	64.01
01-JAN-1939	63.61	61.31	64.81
01-JAN-1940	60.88	61.96	65.75
01-JAN-1941	61.35	61.76	66.34
01-JAN-1942	63.99	61.8	66.31
01-JAN-1943	64.01	63.21	68.39
01-JAN-1944	64.81	63.61	68.11
01-JAN-1945	65.75	60.88	68.63
01-JAN-1946	66.34	61.35	68.24
01-JAN-1947	66.31	63.99	69.54
01-JAN-1948	68.39	64.01	69.8
01-JAN-1949	68.11	64.81	70.17
01-JAN-1950	68.63	65.75	70.14
01-JAN-1951	68.24	66.34	70.4
01-JAN-1952	69.54	66.31	70.53
01-JAN-1953	69.8	68.39	70.7
01-JAN-1954	70.17	68.11	70.82
01-JAN-1955	70.14	68.63	71.04
01-JAN-1956	70.4	68.24	70.79
01-JAN-1957	70.53	69.54	70.85
01-JAN-1958	70.7	69.8	70.76
01-JAN-1959	70.82	70.17	71.55
01-JAN-1960	71.04	70.14	71.52
01-JAN-1961	70.79	70.4	71.44
01-JAN-1962	70.85	70.53	72.07
01-JAN-1963	70.76	70.7	71.69
01-JAN-1964	71.55	70.82	71.66
01-JAN-1965	71.52	71.04	71.9
01-JAN-1966	71.44	70.79	72.23
01-JAN-1967	72.07	70.85	72
01-JAN-1968	71.69	70.76	72.19
01-JAN-1969	71.66	71.55	72.38
01-JAN-1970	71.9	71.52	72.65
01-JAN-1971	72.23	71.44	72.64
01-JAN-1972	72	72.07	73.12
01-JAN-1973	72.19	71.69	73.06
01-JAN-1974	72.38	71.66	73.16
01-JAN-1975	72.65	71.9	73.59
01-JAN-1976	72.64	72.23	73.92
01-JAN-1977	73.12	72	74.04
01-JAN-1978	73.06	72.19	74.29
01-JAN-1979	73.16	72.38	74.68
01-JAN-1980	73.59	72.65	74.53
01-JAN-1981	73.92	72.64	74.8
01-JAN-1982	74.04	73.12	75.15
01-JAN-1983	74.29	73.06	75.26
01-JAN-1984	74.68	73.16	75.4
01-JAN-1985	74.53	73.59	75.74
01-JAN-1986	74.8	73.92	75.91
01-JAN-1987	75.15	74.04	76.3
01-JAN-1988	75.26	74.29	76.17
01-JAN-1989	75.4	74.68	76.72
01-JAN-1990	75.74	74.53	76.62
01-JAN-1991	75.91	74.8	76.88
01-JAN-1992	76.3	75.15	77.14
01-JAN-1993	76.17	75.26	77.28
01-JAN-1994	76.72	75.4	77.38
01-JAN-1995	76.62	75.74	77.86
01-JAN-1996	76.88	75.91	78.14
01-JAN-1997	77.14	76.3	78.26
01-JAN-1998	77.28	76.17	78.35
01-JAN-1999	77.38	76.72	78.93
01-JAN-2000	77.86	76.62	79.13
01-JAN-2001	78.14	76.88	79.37
01-JAN-2002	78.26	77.14	79.56
01-JAN-2003	78.35	77.28	79.68
01-JAN-2004	78.93	77.38	80.18
01-JAN-2005	79.13	77.86	80.41
01-JAN-2006	79.37	78.14	80.8
01-JAN-2007	79.56	78.26	80.8
01-JAN-2008	79.68	78.35	80.8
01-JAN-2009	80.18	78.93	80.8
01-JAN-2010	80.41	79.13	80.8
01-JAN-2011	80.8	79.37	80.8

Statement 238

select  
  recorded_year, age,
  first_value(age) over
    ( order by recorded_year
      range between interval '5' year preceding 
            and interval '5' year following ) as fv,
  min(age) over
    ( order by recorded_year
      range between interval '5' year preceding 
            and interval '5' year following ) as minv
from life_expectancy
order by 1

 
RECORDED_YEAR AGE FV MINV
01-JAN-1543 33.94 33.94 33.94
01-JAN-1548 38.82 33.94 33.94
01-JAN-1553 39.59 38.82 22.38
01-JAN-1558 22.38 39.59 22.38
01-JAN-1563 36.66 22.38 22.38
01-JAN-1568 39.67 36.66 36.66
01-JAN-1573 41.06 39.67 39.67
01-JAN-1578 41.56 41.06 41.06
01-JAN-1583 42.7 41.56 37.05
01-JAN-1588 37.05 42.7 37.05
01-JAN-1593 38.05 37.05 37.05
01-JAN-1598 37.82 38.05 37.82
01-JAN-1603 38.53 37.82 37.82
01-JAN-1608 39.59 38.53 36.79
01-JAN-1613 36.79 39.59 36.79
01-JAN-1618 40.31 36.79 33.39
01-JAN-1623 33.39 40.31 33.39
01-JAN-1628 39.69 33.39 33.39
01-JAN-1633 39.72 39.69 34.03
01-JAN-1638 34.03 39.72 34.03
01-JAN-1643 36.32 34.03 34.03
01-JAN-1648 39.74 36.32 36.32
01-JAN-1653 39.14 39.74 33.04
01-JAN-1658 33.04 39.14 33.04
01-JAN-1663 33.27 33.04 32.48
01-JAN-1668 32.48 33.27 32.48
01-JAN-1673 37.41 32.48 32.4
01-JAN-1678 32.4 37.41 31.27
01-JAN-1683 31.27 32.4 31.27
01-JAN-1688 35.93 31.27 31.27
01-JAN-1693 36.35 35.93 35.93
01-JAN-1698 38.06 36.35 36.35
01-JAN-1703 38.47 38.06 38.06
01-JAN-1708 38.5 38.47 36.89
01-JAN-1713 36.89 38.5 35.75
01-JAN-1718 35.75 36.89 35.49
01-JAN-1723 35.49 35.75 25.34
01-JAN-1728 25.34 35.49 25.34
01-JAN-1733 36.34 25.34 25.34
01-JAN-1738 35.26 36.34 34.27
01-JAN-1743 34.27 35.26 34.27
01-JAN-1748 36.47 34.27 34.27
01-JAN-1753 39.77 36.47 36.47
01-JAN-1758 38.12 39.77 35.37
01-JAN-1763 35.37 38.12 35.37
01-JAN-1768 36.19 35.37 35.37
01-JAN-1773 39.09 36.19 36.19
01-JAN-1778 37.74 39.09 35.81
01-JAN-1783 35.81 37.74 35.81
01-JAN-1788 38.97 35.81 35.81
01-JAN-1793 37.92 38.97 37.92
01-JAN-1798 38.93 37.92 37.92
01-JAN-1803 40.02 38.93 38.93
01-JAN-1808 40.58 40.02 40.02
01-JAN-1813 41.25 40.58 40.58
01-JAN-1818 40.84 41.25 40.47
01-JAN-1823 40.47 40.84 40.47
01-JAN-1828 41.43 40.47 40.47
01-JAN-1833 40.89 41.43 40.56
01-JAN-1838 40.56 40.89 40.56
01-JAN-1842 41 40.56 38.52
01-JAN-1843 41.56 40.56 38.52
01-JAN-1844 41.24 41 37.68
01-JAN-1845 42.17 41 37.68
01-JAN-1846 40.15 41 37.68
01-JAN-1847 38.52 41 37.68
01-JAN-1848 39.89 41.56 37.68
01-JAN-1849 37.68 41.24 37.68
01-JAN-1850 42.77 42.17 37.68
01-JAN-1851 40.95 40.15 37.68
01-JAN-1852 40.41 38.52 37.68
01-JAN-1853 39.99 39.89 37.68
01-JAN-1854 39.48 37.68 37.68
01-JAN-1855 40.74 42.77 39.48
01-JAN-1856 42.47 40.95 39.48
01-JAN-1857 40.93 40.41 39.48
01-JAN-1858 39.55 39.99 39.48
01-JAN-1859 40.41 39.48 39.48
01-JAN-1860 41.95 40.74 39.55
01-JAN-1861 41.62 42.47 39.55
01-JAN-1862 42.13 40.93 39.55
01-JAN-1863 40.37 39.55 39.55
01-JAN-1864 39.59 40.41 39.59
01-JAN-1865 39.75 41.95 39.59
01-JAN-1866 40.09 41.62 39.59
01-JAN-1867 42 42.13 39.59
01-JAN-1868 41.7 40.37 39.59
01-JAN-1869 41.34 39.59 39.59
01-JAN-1870 40.61 39.75 39.75
01-JAN-1871 41.14 40.09 40.09
01-JAN-1872 42.72 42 40.61
01-JAN-1873 43.29 41.7 40.61
01-JAN-1874 42.11 41.34 40.61
01-JAN-1875 41.45 40.61 40.61
01-JAN-1876 42.67 41.14 41.14
01-JAN-1877 43.69 42.72 41.45
01-JAN-1878 42.04 43.29 41.45
01-JAN-1879 43.51 42.11 41.45
01-JAN-1880 42.98 41.45 41.45
01-JAN-1881 45.06 42.67 42.04
01-JAN-1882 43.99 43.69 42.04
01-JAN-1883 44.02 42.04 42.04
01-JAN-1884 43.64 43.51 42.98
01-JAN-1885 44.57 42.98 42.98
01-JAN-1886 44.59 45.06 43.64
01-JAN-1887 45.08 43.99 43.64
01-JAN-1888 46.28 44.02 43.64
01-JAN-1889 45.93 43.64 43.64
01-JAN-1890 44.12 44.57 44.12
01-JAN-1891 44.43 44.59 44.12
01-JAN-1892 45.59 45.08 44.12
01-JAN-1893 44.68 46.28 44.12
01-JAN-1894 48.28 45.93 44.12
01-JAN-1895 45.41 44.12 44.12
01-JAN-1896 47.07 44.43 44.43
01-JAN-1897 46.45 45.59 44.68
01-JAN-1898 46.14 44.68 44.68
01-JAN-1899 45.25 48.28 45.25
01-JAN-1900 45.62 45.41 45.25
01-JAN-1901 46.93 47.07 45.25
01-JAN-1902 48.36 46.45 45.25
01-JAN-1903 49.54 46.14 45.25
01-JAN-1904 48.15 45.25 45.25
01-JAN-1905 49.92 45.62 45.62
01-JAN-1906 49.6 46.93 46.93
01-JAN-1907 50.57 48.36 48.15
01-JAN-1908 51.02 49.54 48.15
01-JAN-1909 51.67 48.15 48.15
01-JAN-1910 53.26 49.92 49.6
01-JAN-1911 51.23 49.6 49.6
01-JAN-1912 54.31 50.57 50.57
01-JAN-1913 53.36 51.02 47.28
01-JAN-1914 53.21 51.67 47.28
01-JAN-1915 51.21 53.26 47.28
01-JAN-1916 54.24 51.23 47.28
01-JAN-1917 54.16 54.31 47.28
01-JAN-1918 47.28 53.36 47.28
01-JAN-1919 54.31 53.21 47.28
01-JAN-1920 57.26 51.21 47.28
01-JAN-1921 58.09 54.24 47.28
01-JAN-1922 57.03 54.16 47.28
01-JAN-1923 59.31 47.28 47.28
01-JAN-1924 58.08 54.31 54.31
01-JAN-1925 58.43 57.26 57.03
01-JAN-1926 59.57 58.09 57.03
01-JAN-1927 58.96 57.03 57.03
01-JAN-1928 59.92 59.31 57.63
01-JAN-1929 57.63 58.08 57.63
01-JAN-1930 60.78 58.43 57.63
01-JAN-1931 60.01 59.57 57.63
01-JAN-1932 60.53 58.96 57.63
01-JAN-1933 60.58 59.92 57.63
01-JAN-1934 61.31 57.63 57.63
01-JAN-1935 61.96 60.78 60.01
01-JAN-1936 61.76 60.01 60.01
01-JAN-1937 61.8 60.53 60.53
01-JAN-1938 63.21 60.58 60.58
01-JAN-1939 63.61 61.31 60.88
01-JAN-1940 60.88 61.96 60.88
01-JAN-1941 61.35 61.76 60.88
01-JAN-1942 63.99 61.8 60.88
01-JAN-1943 64.01 63.21 60.88
01-JAN-1944 64.81 63.61 60.88
01-JAN-1945 65.75 60.88 60.88
01-JAN-1946 66.34 61.35 61.35
01-JAN-1947 66.31 63.99 63.99
01-JAN-1948 68.39 64.01 64.01
01-JAN-1949 68.11 64.81 64.81
01-JAN-1950 68.63 65.75 65.75
01-JAN-1951 68.24 66.34 66.31
01-JAN-1952 69.54 66.31 66.31
01-JAN-1953 69.8 68.39 68.11
01-JAN-1954 70.17 68.11 68.11
01-JAN-1955 70.14 68.63 68.24
01-JAN-1956 70.4 68.24 68.24
01-JAN-1957 70.53 69.54 69.54
01-JAN-1958 70.7 69.8 69.8
01-JAN-1959 70.82 70.17 70.14
01-JAN-1960 71.04 70.14 70.14
01-JAN-1961 70.79 70.4 70.4
01-JAN-1962 70.85 70.53 70.53
01-JAN-1963 70.76 70.7 70.7
01-JAN-1964 71.55 70.82 70.76
01-JAN-1965 71.52 71.04 70.76
01-JAN-1966 71.44 70.79 70.76
01-JAN-1967 72.07 70.85 70.76
01-JAN-1968 71.69 70.76 70.76
01-JAN-1969 71.66 71.55 71.44
01-JAN-1970 71.9 71.52 71.44
01-JAN-1971 72.23 71.44 71.44
01-JAN-1972 72 72.07 71.66
01-JAN-1973 72.19 71.69 71.66
01-JAN-1974 72.38 71.66 71.66
01-JAN-1975 72.65 71.9 71.9
01-JAN-1976 72.64 72.23 72
01-JAN-1977 73.12 72 72
01-JAN-1978 73.06 72.19 72.19
01-JAN-1979 73.16 72.38 72.38
01-JAN-1980 73.59 72.65 72.64
01-JAN-1981 73.92 72.64 72.64
01-JAN-1982 74.04 73.12 73.06
01-JAN-1983 74.29 73.06 73.06
01-JAN-1984 74.68 73.16 73.16
01-JAN-1985 74.53 73.59 73.59
01-JAN-1986 74.8 73.92 73.92
01-JAN-1987 75.15 74.04 74.04
01-JAN-1988 75.26 74.29 74.29
01-JAN-1989 75.4 74.68 74.53
01-JAN-1990 75.74 74.53 74.53
01-JAN-1991 75.91 74.8 74.8
01-JAN-1992 76.3 75.15 75.15
01-JAN-1993 76.17 75.26 75.26
01-JAN-1994 76.72 75.4 75.4
01-JAN-1995 76.62 75.74 75.74
01-JAN-1996 76.88 75.91 75.91
01-JAN-1997 77.14 76.3 76.17
01-JAN-1998 77.28 76.17 76.17
01-JAN-1999 77.38 76.72 76.62
01-JAN-2000 77.86 76.62 76.62
01-JAN-2001 78.14 76.88 76.88
01-JAN-2002 78.26 77.14 77.14
01-JAN-2003 78.35 77.28 77.28
01-JAN-2004 78.93 77.38 77.38
01-JAN-2005 79.13 77.86 77.86
01-JAN-2006 79.37 78.14 78.14
01-JAN-2007 79.56 78.26 78.26
01-JAN-2008 79.68 78.35 78.35
01-JAN-2009 80.18 78.93 78.93
01-JAN-2010 80.41 79.13 79.13
01-JAN-2011 80.8 79.37 79.37

230 rows selected.

RECORDED_YEAR	AGE	FV	MINV
01-JAN-1543	33.94	33.94	33.94
01-JAN-1548	38.82	33.94	33.94
01-JAN-1553	39.59	38.82	22.38
01-JAN-1558	22.38	39.59	22.38
01-JAN-1563	36.66	22.38	22.38
01-JAN-1568	39.67	36.66	36.66
01-JAN-1573	41.06	39.67	39.67
01-JAN-1578	41.56	41.06	41.06
01-JAN-1583	42.7	41.56	37.05
01-JAN-1588	37.05	42.7	37.05
01-JAN-1593	38.05	37.05	37.05
01-JAN-1598	37.82	38.05	37.82
01-JAN-1603	38.53	37.82	37.82
01-JAN-1608	39.59	38.53	36.79
01-JAN-1613	36.79	39.59	36.79
01-JAN-1618	40.31	36.79	33.39
01-JAN-1623	33.39	40.31	33.39
01-JAN-1628	39.69	33.39	33.39
01-JAN-1633	39.72	39.69	34.03
01-JAN-1638	34.03	39.72	34.03
01-JAN-1643	36.32	34.03	34.03
01-JAN-1648	39.74	36.32	36.32
01-JAN-1653	39.14	39.74	33.04
01-JAN-1658	33.04	39.14	33.04
01-JAN-1663	33.27	33.04	32.48
01-JAN-1668	32.48	33.27	32.48
01-JAN-1673	37.41	32.48	32.4
01-JAN-1678	32.4	37.41	31.27
01-JAN-1683	31.27	32.4	31.27
01-JAN-1688	35.93	31.27	31.27
01-JAN-1693	36.35	35.93	35.93
01-JAN-1698	38.06	36.35	36.35
01-JAN-1703	38.47	38.06	38.06
01-JAN-1708	38.5	38.47	36.89
01-JAN-1713	36.89	38.5	35.75
01-JAN-1718	35.75	36.89	35.49
01-JAN-1723	35.49	35.75	25.34
01-JAN-1728	25.34	35.49	25.34
01-JAN-1733	36.34	25.34	25.34
01-JAN-1738	35.26	36.34	34.27
01-JAN-1743	34.27	35.26	34.27
01-JAN-1748	36.47	34.27	34.27
01-JAN-1753	39.77	36.47	36.47
01-JAN-1758	38.12	39.77	35.37
01-JAN-1763	35.37	38.12	35.37
01-JAN-1768	36.19	35.37	35.37
01-JAN-1773	39.09	36.19	36.19
01-JAN-1778	37.74	39.09	35.81
01-JAN-1783	35.81	37.74	35.81
01-JAN-1788	38.97	35.81	35.81
01-JAN-1793	37.92	38.97	37.92
01-JAN-1798	38.93	37.92	37.92
01-JAN-1803	40.02	38.93	38.93
01-JAN-1808	40.58	40.02	40.02
01-JAN-1813	41.25	40.58	40.58
01-JAN-1818	40.84	41.25	40.47
01-JAN-1823	40.47	40.84	40.47
01-JAN-1828	41.43	40.47	40.47
01-JAN-1833	40.89	41.43	40.56
01-JAN-1838	40.56	40.89	40.56
01-JAN-1842	41	40.56	38.52
01-JAN-1843	41.56	40.56	38.52
01-JAN-1844	41.24	41	37.68
01-JAN-1845	42.17	41	37.68
01-JAN-1846	40.15	41	37.68
01-JAN-1847	38.52	41	37.68
01-JAN-1848	39.89	41.56	37.68
01-JAN-1849	37.68	41.24	37.68
01-JAN-1850	42.77	42.17	37.68
01-JAN-1851	40.95	40.15	37.68
01-JAN-1852	40.41	38.52	37.68
01-JAN-1853	39.99	39.89	37.68
01-JAN-1854	39.48	37.68	37.68
01-JAN-1855	40.74	42.77	39.48
01-JAN-1856	42.47	40.95	39.48
01-JAN-1857	40.93	40.41	39.48
01-JAN-1858	39.55	39.99	39.48
01-JAN-1859	40.41	39.48	39.48
01-JAN-1860	41.95	40.74	39.55
01-JAN-1861	41.62	42.47	39.55
01-JAN-1862	42.13	40.93	39.55
01-JAN-1863	40.37	39.55	39.55
01-JAN-1864	39.59	40.41	39.59
01-JAN-1865	39.75	41.95	39.59
01-JAN-1866	40.09	41.62	39.59
01-JAN-1867	42	42.13	39.59
01-JAN-1868	41.7	40.37	39.59
01-JAN-1869	41.34	39.59	39.59
01-JAN-1870	40.61	39.75	39.75
01-JAN-1871	41.14	40.09	40.09
01-JAN-1872	42.72	42	40.61
01-JAN-1873	43.29	41.7	40.61
01-JAN-1874	42.11	41.34	40.61
01-JAN-1875	41.45	40.61	40.61
01-JAN-1876	42.67	41.14	41.14
01-JAN-1877	43.69	42.72	41.45
01-JAN-1878	42.04	43.29	41.45
01-JAN-1879	43.51	42.11	41.45
01-JAN-1880	42.98	41.45	41.45
01-JAN-1881	45.06	42.67	42.04
01-JAN-1882	43.99	43.69	42.04
01-JAN-1883	44.02	42.04	42.04
01-JAN-1884	43.64	43.51	42.98
01-JAN-1885	44.57	42.98	42.98
01-JAN-1886	44.59	45.06	43.64
01-JAN-1887	45.08	43.99	43.64
01-JAN-1888	46.28	44.02	43.64
01-JAN-1889	45.93	43.64	43.64
01-JAN-1890	44.12	44.57	44.12
01-JAN-1891	44.43	44.59	44.12
01-JAN-1892	45.59	45.08	44.12
01-JAN-1893	44.68	46.28	44.12
01-JAN-1894	48.28	45.93	44.12
01-JAN-1895	45.41	44.12	44.12
01-JAN-1896	47.07	44.43	44.43
01-JAN-1897	46.45	45.59	44.68
01-JAN-1898	46.14	44.68	44.68
01-JAN-1899	45.25	48.28	45.25
01-JAN-1900	45.62	45.41	45.25
01-JAN-1901	46.93	47.07	45.25
01-JAN-1902	48.36	46.45	45.25
01-JAN-1903	49.54	46.14	45.25
01-JAN-1904	48.15	45.25	45.25
01-JAN-1905	49.92	45.62	45.62
01-JAN-1906	49.6	46.93	46.93
01-JAN-1907	50.57	48.36	48.15
01-JAN-1908	51.02	49.54	48.15
01-JAN-1909	51.67	48.15	48.15
01-JAN-1910	53.26	49.92	49.6
01-JAN-1911	51.23	49.6	49.6
01-JAN-1912	54.31	50.57	50.57
01-JAN-1913	53.36	51.02	47.28
01-JAN-1914	53.21	51.67	47.28
01-JAN-1915	51.21	53.26	47.28
01-JAN-1916	54.24	51.23	47.28
01-JAN-1917	54.16	54.31	47.28
01-JAN-1918	47.28	53.36	47.28
01-JAN-1919	54.31	53.21	47.28
01-JAN-1920	57.26	51.21	47.28
01-JAN-1921	58.09	54.24	47.28
01-JAN-1922	57.03	54.16	47.28
01-JAN-1923	59.31	47.28	47.28
01-JAN-1924	58.08	54.31	54.31
01-JAN-1925	58.43	57.26	57.03
01-JAN-1926	59.57	58.09	57.03
01-JAN-1927	58.96	57.03	57.03
01-JAN-1928	59.92	59.31	57.63
01-JAN-1929	57.63	58.08	57.63
01-JAN-1930	60.78	58.43	57.63
01-JAN-1931	60.01	59.57	57.63
01-JAN-1932	60.53	58.96	57.63
01-JAN-1933	60.58	59.92	57.63
01-JAN-1934	61.31	57.63	57.63
01-JAN-1935	61.96	60.78	60.01
01-JAN-1936	61.76	60.01	60.01
01-JAN-1937	61.8	60.53	60.53
01-JAN-1938	63.21	60.58	60.58
01-JAN-1939	63.61	61.31	60.88
01-JAN-1940	60.88	61.96	60.88
01-JAN-1941	61.35	61.76	60.88
01-JAN-1942	63.99	61.8	60.88
01-JAN-1943	64.01	63.21	60.88
01-JAN-1944	64.81	63.61	60.88
01-JAN-1945	65.75	60.88	60.88
01-JAN-1946	66.34	61.35	61.35
01-JAN-1947	66.31	63.99	63.99
01-JAN-1948	68.39	64.01	64.01
01-JAN-1949	68.11	64.81	64.81
01-JAN-1950	68.63	65.75	65.75
01-JAN-1951	68.24	66.34	66.31
01-JAN-1952	69.54	66.31	66.31
01-JAN-1953	69.8	68.39	68.11
01-JAN-1954	70.17	68.11	68.11
01-JAN-1955	70.14	68.63	68.24
01-JAN-1956	70.4	68.24	68.24
01-JAN-1957	70.53	69.54	69.54
01-JAN-1958	70.7	69.8	69.8
01-JAN-1959	70.82	70.17	70.14
01-JAN-1960	71.04	70.14	70.14
01-JAN-1961	70.79	70.4	70.4
01-JAN-1962	70.85	70.53	70.53
01-JAN-1963	70.76	70.7	70.7
01-JAN-1964	71.55	70.82	70.76
01-JAN-1965	71.52	71.04	70.76
01-JAN-1966	71.44	70.79	70.76
01-JAN-1967	72.07	70.85	70.76
01-JAN-1968	71.69	70.76	70.76
01-JAN-1969	71.66	71.55	71.44
01-JAN-1970	71.9	71.52	71.44
01-JAN-1971	72.23	71.44	71.44
01-JAN-1972	72	72.07	71.66
01-JAN-1973	72.19	71.69	71.66
01-JAN-1974	72.38	71.66	71.66
01-JAN-1975	72.65	71.9	71.9
01-JAN-1976	72.64	72.23	72
01-JAN-1977	73.12	72	72
01-JAN-1978	73.06	72.19	72.19
01-JAN-1979	73.16	72.38	72.38
01-JAN-1980	73.59	72.65	72.64
01-JAN-1981	73.92	72.64	72.64
01-JAN-1982	74.04	73.12	73.06
01-JAN-1983	74.29	73.06	73.06
01-JAN-1984	74.68	73.16	73.16
01-JAN-1985	74.53	73.59	73.59
01-JAN-1986	74.8	73.92	73.92
01-JAN-1987	75.15	74.04	74.04
01-JAN-1988	75.26	74.29	74.29
01-JAN-1989	75.4	74.68	74.53
01-JAN-1990	75.74	74.53	74.53
01-JAN-1991	75.91	74.8	74.8
01-JAN-1992	76.3	75.15	75.15
01-JAN-1993	76.17	75.26	75.26
01-JAN-1994	76.72	75.4	75.4
01-JAN-1995	76.62	75.74	75.74
01-JAN-1996	76.88	75.91	75.91
01-JAN-1997	77.14	76.3	76.17
01-JAN-1998	77.28	76.17	76.17
01-JAN-1999	77.38	76.72	76.62
01-JAN-2000	77.86	76.62	76.62
01-JAN-2001	78.14	76.88	76.88
01-JAN-2002	78.26	77.14	77.14
01-JAN-2003	78.35	77.28	77.28
01-JAN-2004	78.93	77.38	77.38
01-JAN-2005	79.13	77.86	77.86
01-JAN-2006	79.37	78.14	78.14
01-JAN-2007	79.56	78.26	78.26
01-JAN-2008	79.68	78.35	78.35
01-JAN-2009	80.18	78.93	78.93
01-JAN-2010	80.41	79.13	79.13
01-JAN-2011	80.8	79.37	79.37

Statement 239

select *
from 
(
  select  
    recorded_year, age,
    first_value(age) over
      ( order by recorded_year
        range between interval '5' year preceding 
              and interval '5' year following ) as fv,
    min(age) over
      ( order by recorded_year
        range between interval '5' year preceding 
              and interval '5' year following ) as minv
  from life_expectancy
)
where fv != minv
order by 1

 
RECORDED_YEAR AGE FV MINV
01-JAN-1553 39.59 38.82 22.38
01-JAN-1558 22.38 39.59 22.38
01-JAN-1583 42.7 41.56 37.05
01-JAN-1588 37.05 42.7 37.05
01-JAN-1598 37.82 38.05 37.82
01-JAN-1608 39.59 38.53 36.79
01-JAN-1613 36.79 39.59 36.79
01-JAN-1618 40.31 36.79 33.39
01-JAN-1623 33.39 40.31 33.39
01-JAN-1633 39.72 39.69 34.03
01-JAN-1638 34.03 39.72 34.03
01-JAN-1653 39.14 39.74 33.04
01-JAN-1658 33.04 39.14 33.04
01-JAN-1663 33.27 33.04 32.48
01-JAN-1668 32.48 33.27 32.48
01-JAN-1673 37.41 32.48 32.4
01-JAN-1678 32.4 37.41 31.27
01-JAN-1683 31.27 32.4 31.27
01-JAN-1708 38.5 38.47 36.89
01-JAN-1713 36.89 38.5 35.75
01-JAN-1718 35.75 36.89 35.49
01-JAN-1723 35.49 35.75 25.34
01-JAN-1728 25.34 35.49 25.34
01-JAN-1738 35.26 36.34 34.27
01-JAN-1743 34.27 35.26 34.27
01-JAN-1758 38.12 39.77 35.37
01-JAN-1763 35.37 38.12 35.37
01-JAN-1778 37.74 39.09 35.81
01-JAN-1783 35.81 37.74 35.81
01-JAN-1793 37.92 38.97 37.92
01-JAN-1818 40.84 41.25 40.47
01-JAN-1823 40.47 40.84 40.47
01-JAN-1833 40.89 41.43 40.56
01-JAN-1838 40.56 40.89 40.56
01-JAN-1842 41 40.56 38.52
01-JAN-1843 41.56 40.56 38.52
01-JAN-1844 41.24 41 37.68
01-JAN-1845 42.17 41 37.68
01-JAN-1846 40.15 41 37.68
01-JAN-1847 38.52 41 37.68
01-JAN-1848 39.89 41.56 37.68
01-JAN-1849 37.68 41.24 37.68
01-JAN-1850 42.77 42.17 37.68
01-JAN-1851 40.95 40.15 37.68
01-JAN-1852 40.41 38.52 37.68
01-JAN-1853 39.99 39.89 37.68
01-JAN-1855 40.74 42.77 39.48
01-JAN-1856 42.47 40.95 39.48
01-JAN-1857 40.93 40.41 39.48
01-JAN-1858 39.55 39.99 39.48
01-JAN-1860 41.95 40.74 39.55
01-JAN-1861 41.62 42.47 39.55
01-JAN-1862 42.13 40.93 39.55
01-JAN-1864 39.59 40.41 39.59
01-JAN-1865 39.75 41.95 39.59
01-JAN-1866 40.09 41.62 39.59
01-JAN-1867 42 42.13 39.59
01-JAN-1868 41.7 40.37 39.59
01-JAN-1872 42.72 42 40.61
01-JAN-1873 43.29 41.7 40.61
01-JAN-1874 42.11 41.34 40.61
01-JAN-1877 43.69 42.72 41.45
01-JAN-1878 42.04 43.29 41.45
01-JAN-1879 43.51 42.11 41.45
01-JAN-1881 45.06 42.67 42.04
01-JAN-1882 43.99 43.69 42.04
01-JAN-1884 43.64 43.51 42.98
01-JAN-1886 44.59 45.06 43.64
01-JAN-1887 45.08 43.99 43.64
01-JAN-1888 46.28 44.02 43.64
01-JAN-1890 44.12 44.57 44.12
01-JAN-1891 44.43 44.59 44.12
01-JAN-1892 45.59 45.08 44.12
01-JAN-1893 44.68 46.28 44.12
01-JAN-1894 48.28 45.93 44.12
01-JAN-1897 46.45 45.59 44.68
01-JAN-1899 45.25 48.28 45.25
01-JAN-1900 45.62 45.41 45.25
01-JAN-1901 46.93 47.07 45.25
01-JAN-1902 48.36 46.45 45.25
01-JAN-1903 49.54 46.14 45.25
01-JAN-1907 50.57 48.36 48.15
01-JAN-1908 51.02 49.54 48.15
01-JAN-1910 53.26 49.92 49.6
01-JAN-1913 53.36 51.02 47.28
01-JAN-1914 53.21 51.67 47.28
01-JAN-1915 51.21 53.26 47.28
01-JAN-1916 54.24 51.23 47.28
01-JAN-1917 54.16 54.31 47.28
01-JAN-1918 47.28 53.36 47.28
01-JAN-1919 54.31 53.21 47.28
01-JAN-1920 57.26 51.21 47.28
01-JAN-1921 58.09 54.24 47.28
01-JAN-1922 57.03 54.16 47.28
01-JAN-1925 58.43 57.26 57.03
01-JAN-1926 59.57 58.09 57.03
01-JAN-1928 59.92 59.31 57.63
01-JAN-1929 57.63 58.08 57.63
01-JAN-1930 60.78 58.43 57.63
01-JAN-1931 60.01 59.57 57.63
01-JAN-1932 60.53 58.96 57.63
01-JAN-1933 60.58 59.92 57.63
01-JAN-1935 61.96 60.78 60.01
01-JAN-1939 63.61 61.31 60.88
01-JAN-1940 60.88 61.96 60.88
01-JAN-1941 61.35 61.76 60.88
01-JAN-1942 63.99 61.8 60.88
01-JAN-1943 64.01 63.21 60.88
01-JAN-1944 64.81 63.61 60.88
01-JAN-1951 68.24 66.34 66.31
01-JAN-1953 69.8 68.39 68.11
01-JAN-1955 70.14 68.63 68.24
01-JAN-1959 70.82 70.17 70.14
01-JAN-1964 71.55 70.82 70.76
01-JAN-1965 71.52 71.04 70.76
01-JAN-1966 71.44 70.79 70.76
01-JAN-1967 72.07 70.85 70.76
01-JAN-1969 71.66 71.55 71.44
01-JAN-1970 71.9 71.52 71.44
01-JAN-1972 72 72.07 71.66
01-JAN-1973 72.19 71.69 71.66
01-JAN-1976 72.64 72.23 72
01-JAN-1980 73.59 72.65 72.64
01-JAN-1982 74.04 73.12 73.06
01-JAN-1989 75.4 74.68 74.53
01-JAN-1997 77.14 76.3 76.17
01-JAN-1999 77.38 76.72 76.62

127 rows selected.

Analytics - Window boundaries

Additional Information