Demo entry 3300164

help

   

Submitted by anonymous on Dec 08, 2015 at 09:44
Language: SQL. Code size: 296 Bytes.

SELECT local_date_key, avg(delay)::INTEGER
	FROM fact_bus_data, dim_data_quality, dim_nt_line, dim_nt_bus_stop
WHERE data_quality_key = data_quality_id
	AND nt_line_key = nt_line_id
	AND nt_bus_stop_key = nt_stop_id
	AND nt_public_nr = '6'
	AND delay <> -1000000000
GROUP BY local_date_key

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).