CREATE TABLE table_name_21 (s390x VARCHAR, ia64 VARCHAR, alpha VARCHAR)

Which s390x contains a yes ia64 and a no for alpha?
SELECT s390x FROM table_name_21 WHERE ia64 = "yes" AND alpha = "no"
SELECT "s390x" FROM "table_name_21" WHERE "alpha" = "no" AND "ia64" = "yes"