re-write the below queries by using a correlated subquery and by using an inner join:

Query 1

SELECT DISTINCT CategoryName

FROM Categories

WHERE CategoryID IN

(SELECT DISTINCT CategoryID FROM Products)

ORDER BY CategoryName;

Query 2

SELECT ProductName, DiscountPercent

FROM Products

WHERE DiscountPercent NOT IN (SELECT DiscountPercent

FROM Products

GROUP BY DiscountPercent

HAVING count(DiscountPercent) > 1)

ORDER BY ProductName;