How do you self-assess? Up to what level of complexity do you write requests?

I assess my level as middle. I write queries ranging from simple selections to quite complex ones with multiple JOINs, subqueries, and aggregations. I can optimize queries using indexes and execution plan analysis to ensure acceptable performance. For example, I can write queries with window functions and CTEs (WITH) if needed.