I have the following nested query which works fine in MariaDB(MySql).
Code: Select all
select player, timesplayed, avgscore from
(select player, count(score) as timesplayed, avg(score) as avgscore from bdata where year(playdate)='2017' group by pid)as t
order by avgscore desc;
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
I would like to know how to convert this so it works in LibreOffice Base. Also where is the documentation for HSQLDB that will show me the syntax for the DB?
Thanks R