In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.

PROC SQL allows a subquery (contained in parentheses) at any point in an expression where a simple column value or constant can be used. In this case, a subquery must return a single value, that is, ...

This repository contains SQL subquery practice problems using an employeesales table. Each query is designed to help users understand how to apply subqueries in real-world business scenarios such as ...