FROM pizza_sales WHERE DATE_PART('HOUR',order_time)=12 GROUP BY pizza_category ; SELECT COUNT(DISTINCT(order_id)) FROM pizza_sales WHERE pizza_category='Chicken'; ...