select empno, salesqty, salesprice from sales where not (sal.salestype = 'B'); go