title: SQL Join and Count
body: <p>I want to join two tables and get data against an ID from the first table and count a column record from the second table against the same ID. I want a single query which gives me that output.</p>