ค้นหาชื่อสิ่งอำนวยความสะดวกที่หอพัก Smith Hall มี
Find the name of amenities Smith Hall dorm have.
df_has_amenity = pd.DataFrame(columns=['dormid', 'amenid']); df_dorm_amenity = pd.DataFrame(columns=['amenity_name', 'amenid']); df_dorm = pd.DataFrame(columns=['dormid', 'dorm_name'])
df_dorm_amenity[df_dorm_amenity['amenid'].isin(df_has_amenity[df_has_amenity['dormid'].isin(df_dorm[df_dorm['dorm_name'] == 'Smith Hall']['dormid'])]['amenid'])]['amenity_name']