Numbered SELECT statement aliases (e.g., address1, address2, etc.) does not display all the aliases in the result. Only the last numbered alias in the statement is displayed. For example,

SELECT firstname AS "First1", lastname AS 'First2'

FROM mdl_user

The result will only show the data for First2.

On our Moodle site, we are using the Snap theme from Open LMS. To go to the ad-hoc report on our site, we go to Admin >> Site home settings >> Reports >> Admin SQL.