title: Get Total and Total where is null in same query
body: <p>I have a table  called Lapt<strong>strong text</strong>opStock with <strong>LaptopStockID</strong> as primary key (each laptop we have in stock gets a unique key)  ,<strong>userid</strong> of who is using that specific laptop (the laptop's don't have to have a userid), and a <strong>LaptopID</strong> which refers to another table <strong>Laptop</strong> which contains all the info about that specific model of laptop (each model has a <strong>LaptopID</strong>)</p>
  <p>What I am trying to achieve is a table with the full model name in the first column (EX: Dell XPS 15 2020)
  they will be &quot;group by&quot; the model, then in the second column I want the total amount of each model where userid is null (to see how many are free for use) and in the 3rd column I need the total amount of those laptops in stock</p>
  <p>so far I have this:</p>
  <p><code>SELECT CONCAT(a.Model,' ',a.BouwJaar) as Model, count(*) as total  FROM Laptopstock as b inner join laptops as a on a.LaptopID = b.LaptopID GROUP BY CONCAT(a.Model,' ',a.BouwJaar)</code></p>
  <p><img src="https://i.stack.imgur.com/5Bhha.png" alt="enter image description here" /></p>
  <p>That is the result, so the total amount of laptops.</p>
  <p>so all I would need now is how to I get the amount where is null into the same table?</p>
  <p>Thanks in advance</p>