CREATE TABLE artist (artist_name VARCHAR2, country VARCHAR2)
CREATE TABLE song (artist_name VARCHAR2, resolution NUMBER)

Find the name and country of origin for all artists who have release at least one song of resolution above 900.
SELECT T1.artist_name, T1.country FROM artist AS T1 JOIN song AS T2 ON T1.artist_name = T2.artist_name WHERE T2.resolution > 900 GROUP BY T2.artist_name HAVING COUNT(*) >= 1
SELECT "T1"."artist_name", "T1"."country" FROM "artist" "T1" JOIN "song" "T2" ON "T1"."artist_name" = "T2"."artist_name" AND "T2"."resolution" > 900 GROUP BY "T2"."artist_name" HAVING COUNT(*) >= 1