The first challenge should include GROUP BY
The first challenge should include GROUP BY because some subjects are repeated
Steven Parker177,563 Points
That's certainly one way to do it. An even easier way would be to use the
-- Which subjects are taught at Jefferson Middle School? SELECT DISTINCT name FROM subjects;
I tried that first and no change then I tried GROUP BY and that worked. weird..
Yes that was it. I would then use GROUP BY to order it
Yes silly me !