SQL query string

SELECT pcode,
       productName,
       SUM(soldQty),
       SUM(cash) AS cash,
       SUM(credit) AS credit,
       stockQty
FROM   (SELECT p.pcode,
               p.productName,
               i.soldQty,
               k.stockQty,
               k.p_code,
               CASE WHEN item_for ="cs" THEN soldPrice ELSE 0 END AS cash,
               CASE WHEN item_for ="cd" THEN soldPrice ELSE 0 END AS credit
FROM tbl_products p
INNER JOIN tbl_sold_items i ON p.pcode = i.pcode INNER JOIN tbl_stock k ON p.pcode = k.p_code WHERE i.date_created BETWEEN @start_date AND @end_date AND i.shop_id = @shop_id) AS sales GROUP BY pcode