maxClic is array due to subquery. You should do maxClic[0]
But you can use following approach for MIN/MAX
SELECT RAW MAX([t.clicks,t])[1] FROM myBucket AS t ;
Explanation given here Select non-group by fields using sql query
maxClic is array due to subquery. You should do maxClic[0]
But you can use following approach for MIN/MAX
SELECT RAW MAX([t.clicks,t])[1] FROM myBucket AS t ;
Explanation given here Select non-group by fields using sql query