CREATE VIEW Calls
AS
SELECT
start.RecordCallId AS CallId,
start.RecordTimestamp AS CallStart,
end.RecordTimestamp AS CallEnd,
start.RecordSource AS CallSource,
start.RecordDestination AS CallDestination,
COALESCE(CASE
WHEN STRFTIME('%H:%M:%S', start.RecordTimestamp) >= '06:00:00' AND
STRFTIME('%H:%M:%S', start.RecordTimestamp) < '22:00:00'
THEN price.PriceStandardFixed
ELSE price.PriceReducedFixed
END, 0.0) +
COALESCE(CASE
WHEN STRFTIME('%H:%M:%S', start.RecordTimestamp) >= '06:00:00' AND