/media/sda-magnetic/david/Dok-15-2023-11-27/fernuni-hagen/cs-i-ii/old-cs-2-02/statistik2022-06-10/sql-without-homepage/statistik58.txt

SET @k := 0;
SELECT @k:=@k+1, ip, datetime FROM ip_datetime;
SELECT @k:=@k+1, ip, datetime, COUNT(ip) FROM ip_datetime GROUP BY ip;
SELECT @k:=@k+1, ip, datetime, COUNT(ip) FROM ip_datetime GROUP BY ip ORDER BY COUNT(ip);
SET @k:=0;
SELECT @k:=@k+1, ip, datetime, COUNT(ip),COUNT(ip)/8679 FROM ip_datetime GROUP BY ip ORDER BY COUNT(ip);