Chinook sql output problem

%%sql
SELECT *
FROM invoice
INNER JOIN(
    SELECT MAX(total) t
    FROM invoice
)maxtotal
ON maxtotal.t = invoice.total

With the output above I do not get the column name ‘total’ in the output please could you advise why not and how to get it?
I have selected all columns : SELECT *
so believed I would see all column names.

This is an ad-hoc query , although related to mission chinook

See far right column in screenshot below the fitrst output table has ‘total’ bottom does not.

1 Like

Your query’s output

Query with only invoice table columns

What exactly is missing here?

1 Like

yes sorry i did not scroll all the way to the right so did not see as many columns
so i tot did not appear in output

1 Like