[ad_1]
Well TESTED
SELECT sp.NAME
FROM salesperson AS sp
INNER JOIN order AS ord
ON salesperson.sid = ord.sid
GROUP BY sp.sid
HAVING Count(ord.oid) >= 2
[ad_2]
solved SQL query for the following db [closed]
[ad_1]
Well TESTED
SELECT sp.NAME
FROM salesperson AS sp
INNER JOIN order AS ord
ON salesperson.sid = ord.sid
GROUP BY sp.sid
HAVING Count(ord.oid) >= 2
[ad_2]
solved SQL query for the following db [closed]