I am not a big fan of single letter acronyms as they often make the code less readable. Could you avoid the use of table alias at all or use acronyms that makes this query more readable (e.g. assets, site and gmvs)?