ค้นหาชื่อและนามสกุลของนักเรียนที่อาศัยอยู่ในหอพักที่มีสิ่งอำนวยความสะดวกครบครัน TV Lounge
Find the first and last name of students who are living in the dorms that have amenity TV Lounge.
has_amenity = {'dormid': [], 'amenid': []}; lives_in = {'stuid': [], 'dormid': []}; student = {'fname': [], 'lname': [], 'stuid': []}; 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']; student[student['stuid'].isin(lives_in[lives_in['dormid'].isin(dorm_ids_with_tv_lounge)]['stuid'])][['fname', 'lname']]