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

INSERT INTO excersize02 SELECT * FROM ip_datetime;
SET @k := 0;
SELECT ip, @k := @k+1 FROM ip_datetime;
SELECT ip, COUNT(ip), @k := @k+1 FROM ip_datetime GROUP BY ip;
SELECT ip, COUNT(ip), @k := @k+1 FROM ip_datetime GROUP BY ip ORDER BY COUNT(ip);
SELECT COUNT(*) FROM ip_datetime;
SELECT ip, COUNT(ip), COUNT(ip)/7457, @k := @k+1 FROM ip_datetime GROUP BY ip ORDER BY COUNT(ip);