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

SELECT ip,COUNT(*) FROM ip_datetime GROUP BY ip ORDER BY COUNT(
SELECT ip,COUNT(*) FROM ip_datetime GROUP BY ip ORDER BY COUNT( *);
CREATE TABLE execercise01 (ip VARCHAR (32), datetime DATETIME);
INSERT INTO execercise01 SELECT * FROM ip_datetime;
CREATE TABLE excersize01a (ip VARCHAR (32), datetime DATETIME, n INTEGER, nABS INTEGER);
SET @n=0;
INSERT INTO execersize01a SELECT ip, ip_datetime, @n:=@n+1, COUNT(ip) GROUP BY ip;
INSERT INTO execersize01a SELECT ip, ip_datetime FROM ip_datetime, @n:=@n+1, COUNT(ip) GROUP BY ip;

Falsch:

INSERT INTO execersize01a SELECT ip, ip_datetime, @n:=@n+1, COUNT(ip) GROUP BY ip FROM ip_datetime; 


INSERT INTO execersize01a SELECT ip, ip_datetime, @n:=@n+1, COUNT(ip) FROM ip_datetime GROUP BY ip; 
INSERT INTO excersize01a SELECT ip, ip_datetime, @n:=@n+1, COUNT(ip) FROM ip_datetime GROUP BY ip; 
INSERT INTO excersize01a SELECT ip, datetime, @n:=@n+1, COUNT(ip) FROM ip_datetime GROUP BY ip; 
SET @k := 0;

SELECT ip, datetime, @n := @n+1 FROM ip_datetime;
SELECT COUNT(*) FROM ip_datetime; 
SELECT nABS/4905 FROM excersize01a;
SELECT nABS/4905 FROM excersize01a ORDER BY nABS/4905;