'''PostgreSQL'''
<pre>
CREATE VIEW `my_view` AS
SELECT
extract(year from my_view2."DateofAccidenDateofAccident") - extract(year from my_view2."DateofBirth") AS "Age",
extract(year from my_view2."DateofAccident") AS "Year",
extract(month from my_view2."DateofAccident") AS "Month"