CREATE TABLE ALBUM (Title VARCHAR2, AlbumId VARCHAR2)
CREATE TABLE TRACK (AlbumID VARCHAR2, AlbumId VARCHAR2, UnitPrice NUMBER)

Show the album names and ids for albums that contain tracks with unit price bigger than 1.
SELECT T1.Title, T2.AlbumID FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumID = T2.AlbumID WHERE T2.UnitPrice > 1 GROUP BY T2.AlbumID
SELECT "T1"."Title", "T2"."AlbumID" FROM "ALBUM" "T1" JOIN "TRACK" "T2" ON "T1"."AlbumID" = "T2"."AlbumID" AND "T2"."UnitPrice" > 1 GROUP BY "T2"."AlbumID"