400 font-bold">SELECT u.id,
  u.name,
  u.email,
  400 font-bold">COUNT(
  o.id
) 400 font-bold">as order_count 
400 font-bold">FROM users u 400 font-bold">LEFT 
400 font-bold">JOIN orders o 400 font-bold">ON u.id = o.user_id 
400 font-bold">WHERE u.active = 1 
400 font-bold">AND u.created_at > 400">'2024-01-01' 
400 font-bold">GROUP 400 font-bold">BY u.id 
400 font-bold">ORDER 400 font-bold">BY order_count 400 font-bold">DESC 
400 font-bold">LIMIT 10