select a row with and excepcion

Hi i need to Create query to select most expensive PC without CD drive for makers who manufacture only PCs my tables are

+-----------------------------------------------------+
         PC

+-----------------------------------------------------+ SERIAL_NUMBER MODEL PRICE SPEED RAM HD CD 1234221 d1 500 600 2048 600 hitachi 1234222 d2 600 600 4096 600 - +---------------------------------------------------+ Laptop +---------------------------------------------------+ SERIAL_NUMBER MODEL PRICE SPEED RAM HD SCREEN 1234211 s-1 500 600 2048 600 15.6 1234212 s-2 600 600 4096 600 15.6 +---------------------------------------------------+ Product +---------------------------------------------------+ MODEL MAKER TYPE s-1 Hitachi laptop s-2 Hitachi laptop s-3 Hitachi laptop d1 Dell pc d2 Dell pc d3 Dell pc +---------------------------------------------------+ Storage +---------------------------------------------------+ STORAGE_ID MODEL SERIAL_NUMBER TRANSFERED_TO 50 s-1 1234211 51 50 s-2 1234212 51