Question

What is the answer to this question please Modify the following query to return the results for Detroit Tigers players from every year EXCEPT 2012:

SELECT playerID, yearID, teamID, AB, H, HR, BB,
H/AB AS BA
FROM Batting
WHERE teamID='DET'

Thank you

Answer 1

Is there another table called that holds the years? If so, you will need to do an inner join between the years table and the batting table on yearID and reference the yeartable.Year in your Select Statement and filter would look like this
WHERE Year <> '2012'

Answer 2

Hi DMunson thank you for your help. I finally figure it out. I forgot to add AND playerID != 'cabremi01'. Once I did that it work. This is the right formula SELECT playerID, yearID, teamID, AB, H, HR, BB,
H/AB AS BA
FROM Batting
WHERE teamID= 'DET' AND yearID >= 2000 AND playerID != 'cabremi01'