Give me all their model names and ram mib
SELECT Model_name,RAM_MiB FROM chip_model WHERE model_name NOT IN  ( SELECT chip_model FROM phone ) 
all their model names refers to SELECT Model_name; ram mib refers to SELECT RAM_MiB; exclude models present in another table refers to WHERE model_name NOT IN (SELECT chip_model FROM phone);