need help on my query.
- by Dharmendra
i have one table : nobel(yr, subject, winner)
and i have this query : In which years was the Physics prize awarded but no Chemistry prize.
this is what i tried :
select distinct
yr from nobel where subject='physics' and subject!='chemistry'
but is not working where i am going wrong.
see, i am not here to make my homework from someone. i am here to learn something. so, please give me suggetion.