CREATE TABLE media_types (id VARCHAR2, name VARCHAR2)
CREATE TABLE genres (id VARCHAR2, name VARCHAR2)
CREATE TABLE tracks (name VARCHAR2, genre_id VARCHAR2, media_type_id VARCHAR2)

List the name of tracks belongs to genre Rock or media type is MPEG audio file.
SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id JOIN media_types AS T3 ON T3.id = T2.media_type_id WHERE T1.name = "Rock" OR T3.name = "MPEG audio file"
SELECT "T2"."name" FROM "genres" "T1" JOIN "tracks" "T2" ON "T1"."id" = "T2"."genre_id" JOIN "media_types" "T3" ON ("MPEG audio file" = "T3"."name" OR "Rock" = "T1"."name") AND "T2"."media_type_id" = "T3"."id"