The quantity sold was set to 1 so that for each row returned that was not NULL, would have the value of 1 and then when summed would create the total number of sold. After some more research I cam across something I've used before but totally forgot about ... the HAVING clause.
HAVING Qty > Qty_Sold
This did exactly what I needed.
Thanks Jason!