Case study 1 question C

Can you what is wrong in my query i have attached the snapshot of it.