I need a report, a side by side inventory count if you will...

I tried a few statements but just can not get it.

But it would be something like this:

Code:
SELECT
	inventory.sku
,    	inventory.description_short
FROM
   	inventory
  JOIN inventory_history
    ON inventory.sku = inventory_history.sku

  (
    SELECT SUM(remaining)
    FROM  inventory_history
WHERE
            inventory_history.store_id = 5
    ) AS qty_cortes,
    (
    SELECT SUM(remaining)

    FROM    inventory_history
WHERE
            inventory_history.store_id = 4

    ) AS qty_rio,
(
    SELECT SUM(remaining)
    FROM  inventory_history
WHERE
            inventory_history.store_id = 5
    ) AS qty_brickbay,
 GROUP BY 
   inventory.sku
Please let me know how I could do this, Thanks, AM