select text, min(link), avg(link), max(link), var_pop(link), stddev_pop(link), count(*) from wetter left join alfredi using(ahour) group by `text`