probably an easy for most of you

[Stéphan Dorion]

Here my code do not work:

..but I cannot find the solution

Here my table :

nobl

yr. subject winner

1960 Chem Smith
1974 Lit Dorian
1965 Chem Burt
1963 Lit Vold

Show the year, subject, and name of physics winners for 1980 together with the chemistry winners for 1984

SELECT * FROM nobl
WHERE subject =('Chem') AND
yr = 1960 AND
WHERE subject=('Lit') AND
yr = 1974

Not working...

Please help a newbie... :-)