Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
Hi, Im learning SQL and I've hit a bit of a wall early on.... I have these 2 statements [CODE]SELECT AcNum, FamName, GiveName, DeptNum, count(AcNum) FROM academic NATURAL JOIN interest GROUP BY AcNum HAVING count(AcNum) < 4[/CODE] [CODE]SELECT GiveName, FamName, DeptNum, AcNum FROM academic NATURAL JOIN department WHERE LOWER(state)= 'ny';[/CODE] … |