where timehour >= :start_time and timehour < :end_time to_char(timestamp, 'MM/DD HH24') || ':00' to_char(timestamp, 'Mon DD') select $load_and_memory_averages_sql, count(*) as count, $day_sql as day from ad_monitoring_top $time_clause group by $day_sql [ad_order_by_from_sort_spec $orderbysystem $top_system_avg_table_def]