PSET 7 for 6.sql, Terminal just hangs when I execute it. Can anyone tell me why this wouldn't work? I've tried every variation I could think of (and several I found online) for this and none of them work, Terminal just shows a solid white block like it's processing but it never does anything.
SELECT AVG(rating) FROM ratings INNER JOIN movies WHERE year = 2012
I've tried regular JOIN, replacing WHERE with ON, specifying ratings.rating instead of just rating, literally everything I can think of. Where am I going wrong?