how many orders has customer made database python

1SELECT customers_firstname, customers_lastname,
2COUNT(orders_id) AS Number
3FROM customers LEFT JOIN orders AS o
4USING (customers_id) GROUP BY (o.customers_id)
5ORDER BY Number DESC LIMIT 5;