Posrgresql query in Grafana

,
1

I have a query showing result in postgresql 10

SELECT AVG(d1.pushing_force)

FROM drawing d1, (
SELECT coil_id, max(drawing_force) as mdrawing_force
FROM drawing
GROUP BY coil_id
) d2
WHERE d1.pushing_force > d2.mdrawing_force
AND d1.coil_id = d2.coil_id
GROUP BY d1.coil_id
ORDER BY d1.coil_id

Please let me know how write this in grafana v7.1.0:
I tried this:

SELECT
now() AS time,
coil_id ,
avg(d1.pushing_force)*0.1
FROM drawing d1, (
SELECT coil_id, max(drawing_force) as mdrawing_force
FROM drawing
GROUP BY coil_id
) d2

WHERE
$__timeFilter(“time”) AND d1.pushing_force > d2.mdrawing_force
AND d1.coil_id = d2.coil_id
GROUP BY time, d1.coil_id
ORDER BY time, d1.coil_id

but not working properly. Kindly help me.