SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Create table If Not Exists Activity (player_id int, device_id int, event_date date, games_played int); Truncate table Activity; insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-03-01', '5'); insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-05-02', '6'); insert into Activity (player_id, device_id, event_date, games_played) values ('2', '3', '2017-06-25', '1'); insert into Activity (player_id, device_id, event_date, games_played) values ('3', '1', '2016-03-02', '0'); insert into Activity (player_id, device_id, event_date, games_played) values ('3', '4', '2018-07-03', '5'); SELECT * FROM Activity; SELECT * FROM Activity; SELECT A.player_id, A.event_date FROM Activity A JOIN (SELECT player_id, COUNT(*) AS Count_of_PlayerId FROM Activity GROUP BY player_id) AS B ON B.player_id = A.player_id;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear