SELECT HOUR(t.transaction_date) hour,COUNT(t.id) transactions,AVG(TIMESTAMPDIFF(MINUTE,t.created_at,t.updated_at)) processing_time FROM transactions t WHERE t.type="sell" AND t.shipping_status IS NOT NULL GROUP BY HOUR(t.transaction_date) ORDER BY processing_time;