To write Custom Reports an implementer should be good with SQL statements. Most reports require you to pull database from MySQL / Postgres DB, and having a good grasp on SQL will help.
Given below a set of common SQL clauses an implementer should learn to master custom reports.
Some resources are given below: