Untitled

mail@pastecode.io avatar
unknown
sql
19 days ago
227 B
5
Indexable
Never
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')
)