<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div>
<div>I have a query like this</div>
<div> </div>
<div>SELECT avg(_gfsGEO_RECHTSWERT) as x, avg(_gfsGEO_HOCHWERT) as y, Filename, _gfsfid, _gfsKURZNAME, avg(T_C) FROM Temp_near_GFS group by Filename, _gfsfid</div>
<div> </div>
<div>to average some values accoring to their attributes.</div>
<div>I get a new virtual layer and the attribute table content looks fine, x and y are populated as well with reasonable values.</div>
<div> </div>
<div>What I am struggling is to create the actual points / geometries to make the locations visible.</div>
<div>How do I modify the statement so that I can specify a "geometry column" as expected by the Creat/Modify Virtual layer GUI in the bottom of the form?</div>
<div> </div>
<div>TIA Roland</div></div></body></html>