แพ้คนไหนมีแต้ม 28 และเสมอน้อยกว่า 8?
Which Lost has Points of 28 and a Drawn smaller than 8?
df = pd.DataFrame(columns=['lost', 'points', 'drawn'])
df.loc[(df['points'] == 28) & (df['drawn'] < 8), 'lost'].mean()