CREATE VIEW "statview" ("fullname", "dayorhour", "average", "avg", "avgseconds", "stddeviation", "stddev", "stddevseconds", "totalcount", "periodendts", "name", "weekdayid") AS
SELECT "d"."fullname", "c"."dayorhour", "c"."average", char(dbo._time(dbo.int4(c.average + 0.5))), dbo.mod(c.average + 0.5, 60), "c"."stddeviation", char(dbo._time(dbo.int4(c.stddeviation + 0.5))), dbo.mod(c.stddeviation + 0.5, 60), "c"."totalcount", "c"."periodendts", "a"."name", "e"."id"
FROM "statistic" "a", "statisticgrouping" "b", "statisticaverages" "c", "secure_person" "d", "weekday" "e"
WHERE c.statisticgroupingid = b.id AND b.personid = d.id AND b.statisticid = a.id AND c.dayorhour = e.name
GO
[dbo].[statview]