Table: spectrasonics_media
Columns: music_library
year
media_type
name_of_the_media
composition_name
composer
genre

Question: What is every media type for the Psychedelic Trance genre?
SQL: SELECT "media_type" FROM spectrasonics_media WHERE "genre" = 'Psychedelic Trance'

Question: Who is every composer for the media named Hall of Dreams?
SQL: SELECT "composer" FROM spectrasonics_media WHERE "name_of_the_media" = 'Hall Of Dreams'

Question: What is every media type for the Dub genre?
SQL: SELECT "media_type" FROM spectrasonics_media WHERE "genre" = 'Dub'

Question: What is every media type for the World genre?
SQL: SELECT "media_type" FROM spectrasonics_media WHERE "genre" = 'World'

Question: What is every composition name when the music library is Heart of Asia and media type is album with the Trance genre?
SQL: SELECT "composition_name" FROM spectrasonics_media WHERE "music_library" = 'Heart of Asia' AND "media_type" = 'Album' AND "genre" = 'Trance'