CREATE TABLE table_12474 ("State" CLOB, "Type" CLOB, "Name" CLOB, "Title" CLOB, "Royal house" CLOB, "From" CLOB)

Which name has a state of Yan?
SELECT "Name" FROM table_12474 WHERE "State" = 'yan'
SELECT "Name" FROM "table_12474" WHERE "State" = 'yan'