The continuing economic uncertainty brought by the pandemic has supercharged many organizations to “do more with less,” tasking development teams (among others) with reducing resource and cost drains ...

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.