I'd include the ability to handle the possible effects of NULL values, and knowledge of how and why to use Stored Procedures.

I'm another person who hasn't ever needed to use APPLY for any actual work.