[CR #333873} SQL derivced tables cannot have unnamed columns.
For example:
select * from (select sum(advance) from titles) d1
causesan error message.
Workaround: Rewrite the query using derived column list or the “AS” clause.
For example:
select * from (select sum(advance) from titles) d1(a1)
or:
select * from (select sum(advance) as a1 from titles) d1
