搜尋交集結果

假設有個看電影的Log類似
document structure: userName, movies

[
{"userName":"user_1","movies":"movie_A"},
{"userName":"user_1","movies":"movie_B"},
{"userName":"user_2","movies":"movie_C"},
{"userName":"user_3","movies":"movie_A"},
{"userName":"user_3","movies":"movie_C"},
{"userName":"user_4","movies":"movie_A"},
{"userName":"user_4","movies":"movie_B"},
{"userName":"user_4","movies":"movie_C"},
]
 

今天要找出看了電影A又看了電影B的人
如何使用語法取得名單? (也就是user_1與user_4)
 
用SQL語法實現大概會像是
 
SELECT 
    t1.userName
FROM
    tableName t1
        INNER JOIN
    tableName t2 ON t1.userName = t2.userName
WHERE
    t1.movies = 'movie_A'
        AND t2.movies = 'movie_B';