Show me the title of album id 1?
SELECT T1.Title FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId   =   T2.ArtistID where T1.AlbumId  =  1
title of album id 1 refers to a condition where T1.AlbumId = 1; joining tables ALBUM and ARTIST on their common attribute ArtistId;