Untitled

 avatar
unknown
sql
2 years ago
227 B
8
Indexable
SELECT user_id, city, review_date
FROM hotel
WHERE EXISTS (
    SELECT hotel_id
    FROM review2
    WHERE hotel.id = review2.hotel_id AND review2.user_id IN ('Helsinki_Uusimaa') AND review2.user_id IN ('Rovaniemi_Lapland')
) 
Editor is loading...