Database: e_commerce
Question: How many orders has each gender of customers placed?
SQL:
SELECT T1.gender_code ,  count(*) FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.gender_code