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