Query 3

SELECT sid, count(distinct dept) FROM Took JOIN Offering ON Took.oid = Offering.oid GROUP BY sid;

Query 4a

SELECT * FROM One NATURAL RIGHT JOIN Two;

Query 4b

SELECT * FROM One NATURAL LEFT JOIN Two;