Firebird query explainer

Explain and understand query for Firebird.