-- Database schema
| artists : id [ INT ] primary_key , name [ TEXT ] | sqlite_sequence : name [ TEXT ] , seq [ TEXT ] | albums : id [ INT ] primary_key , title [ TEXT ] , artist_id [ INT ] albums.artist_id = artists.id | employees : id [ INT ] primary_key , last_name [ TEXT ] , first_name [ TEXT ] , title [ TEXT ] , reports_to [ INT ] employees.reports_to = employees.id , birth_date [ TEXT ] , hire_date [ TEXT ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , country [ TEXT ] , postal_code [ TEXT ] , phone [ TEXT ] , fax [ TEXT ] , email [ TEXT ] | customers : id [ INT ] primary_key , first_name [ TEXT ] , last_name [ TEXT ] , company [ TEXT ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , country [ TEXT ] , postal_code [ TEXT ] , phone [ TEXT ] , fax [ TEXT ] , email [ TEXT ] , support_rep_id [ INT ] customers.support_rep_id = employees.id | genres : id [ INT ] primary_key , name [ TEXT ] | invoices : id [ INT ] primary_key , customer_id [ INT ] invoices.customer_id = customers.id , invoice_date [ TEXT ] , billing_address [ TEXT ] , billing_city [ TEXT ] , billing_state [ TEXT ] , billing_country [ TEXT ] , billing_postal_code [ TEXT ] , total [ INT ] | media_types : id [ INT ] primary_key , name [ TEXT ] | tracks : id [ INT ] primary_key , name [ TEXT ] , album_id [ INT ] tracks.album_id = albums.id , media_type_id [ INT ] tracks.media_type_id = media_types.id , genre_id [ INT ] tracks.genre_id = genres.id , composer [ TEXT ] , milliseconds [ INT ] , bytes [ INT ] , unit_price [ INT ] | invoice_lines : id [ INT ] primary_key , invoice_id [ INT ] invoice_lines.invoice_id = invoices.id , track_id [ INT ] invoice_lines.track_id = tracks.id , unit_price [ INT ] , quantity [ INT ] | playlists : id [ INT ] primary_key , name [ TEXT ] | playlist_tracks : playlist_id [ INT ] primary_key playlist_tracks.playlist_id = playlists.id , track_id [ INT ] playlist_tracks.track_id = tracks.id |
-- -- What are the names of all tracks that belong to the Rock genre and whose media type is MPEG?

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";