CREATE TABLE table_name_76 (intra_molecular_structure VARCHAR2, comparative VARCHAR2, name VARCHAR2)

Which Intra-molecular structure has a Comparative of no, and a Name of mitarget?
SELECT intra_molecular_structure FROM table_name_76 WHERE comparative = "no" AND name = "mitarget"
SELECT "intra_molecular_structure" FROM "table_name_76" WHERE "comparative" = "no" AND "mitarget" = "name"