Hello everyone !
I would like to do an advanced query by the Rest API which look like something like this :
SELECT CAST(AVG(nbr_trip) AS integer)
FROM (
SELECT id_people, count(id_trip) AS nbr_trip
FROM base.trip
GROUP BY id_people
ORDER BY id_people
) AS tmp_query
My goal is to return back only a number which is the average of a count but the REST UI doesn't seem to allow me to do that...
Someone could help me please ?
Thx by advance !
