Where can I find scenarios to work through T-SQL
You could try to answer query-related questions here or on Stack Overflow. The nice thing about this is that you are solving real problems, not made-up ones, and you can also gain knowledge by seeing how other folks solve those same problems. You're also helping folks, potentially.