1、将查询结果直接写入数据库中的表(已经建好)
INSERT INTO final_song_avescore
SELECT * FROM songidavescore WHERE SongId IN (
SELECT SongID FROM user_seed
);
2、显示联合查询结果
SELECT SeedID FROM `seed_songid` WHERE SeedID NOT IN (
SELECT SeedID FROM final_seed
)
3、分组查询语句
SELECT SeedID,COUNT(SongID) AS 'Song Count' FROM seed_songid GROUP BY SeedID ORDER BY COUNT(SongID) DESC;