Im learning SQL and I've hit a bit of a wall early on....
I have these 2 statements
SELECT AcNum, FamName, GiveName, DeptNum, count(AcNum) FROM academic NATURAL JOIN interest GROUP BY AcNum HAVING count(AcNum) < 4
SELECT GiveName, FamName, DeptNum, AcNum FROM academic NATURAL JOIN department WHERE LOWER(state)= 'ny';
They both work fine independently, but how can I make it one statement and keep the natural join.