subset_games_1.sql

/* Inspired by
https://www.mysqltutorial.org/mysql-subquery/
*/
DROP TABLE IF EXISTS stids;
CREATE TABLE stids SELECT steamid FROM (
    SELECT DISTINCT steamid FROM Games_1) AS stids
    WHERE rand() < 0.1;

SELECT steamid, appid, playtime_forever FROM Games_1
WHERE steamid in (SELECT steamid FROM stids)
INTO OUTFILE '/Volumes/rebrought/data/Games_1_stid_sample.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';