MySQL Throws error after defining the location of table
I have this ‘information’ table below with 4 columns in it: ‘creator_id’,’viewer_id’,’date_format’,’donation’ CREATE TABLE information ( creator_id INT NOT NULL, viewer_id INT NOT NULL, date_format DATE NOT NULL, donation INT NOT NULL ); INSERT INTO twitch.information(creator_id,viewer_id,date_format,donation) VALUES (10,11,’2014-01-02′,34), (20,14,’2014-01-02′,150), (30,15,’2014-01-02′,717), (31,17,’2014-01-02′,177), (32,17,’2014-01-06′,737), (33,16,’2014-01-07′,37), (40,18,’2016-03-08′,442), (41,19,’2016-03-09′,142), (42,10,’2016-03-10′,152), (43,11,’2016-03-11′,512), (44,12,’2016-01-12′,340), (60,0,’2012-01-02′,1000), (70,1,’2012-01-02′,100); SELECT creator_id, MAX(SUM(donation)/COUNT(donation)) AS "TOP… Read More MySQL Throws error after defining the location of table