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
solved SQL query for the following db [closed]
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
solved SQL query for the following db [closed]