I have professionally worked with four different SQL database types PostgreSQL, MySQL & MariaDB (InnoDB), MSSQL SQL Server 2008+ and Oracle 19c+. Over the course of that time I have been asked:

Choosing the right query pattern for the problem

Using NOT EXISTS / EXISTS where appropriate

Avoiding unnecessary nested aggregate subqueries

Understanding joins, filtering, grouping, and set-based logic