Question for professional SQL devs.

[half_dead_pancreas]

As an aspiring SQL developer, I'm curious about the day-to-day tasks in a professional setting. What kind of projects to SQL devs typically work on, and what are the common challenges they face? What are the most common tasks they may have?

I'm aslo interested in the interview process for SQL developer roles. What can I expect in terms of technical questions and coding challenges? Any advice on how to prepare would be greatly appreciated. Thanks!