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

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