title: Calculate number of orders in each category per vendor
body: <p>Here's my code</p>
  <pre><code>SELECT Vendor_ID, COUNT(*) AS no_orders, category_name
  FROM orders
  GROUP BY Vendor_ID, category_name
  </code></pre>
  <p>My question is, is there any other better way for this query?</p>