CREATE TABLE table_name_42 (period_active VARCHAR, artist VARCHAR)

Name the period active for enya
SELECT period_active FROM table_name_42 WHERE artist = "enya"
SELECT "period_active" FROM "table_name_42" WHERE "artist" = "enya"