ค้นหาชื่อหอพักที่ไม่มีสิ่งอำนวยความสะดวก TV Lounge
Find the name of dorms that do not have amenity TV Lounge.
dorm = {'dorm_name': [], 'dormid': []}; has_amenity = {'dormid': [], 'amenid': []}; dorm_amenity = {'amenid': [], 'amenity_name': []}
dorm_ids_with_tv_lounge = has_amenity[has_amenity['amenid'].isin(dorm_amenity[dorm_amenity['amenity_name'] == 'TV Lounge']['amenid'])]['dormid']; dorm[~dorm['dormid'].isin(dorm_ids_with_tv_lounge)]['dorm_name']