CREATE TABLE table_name_46 (design VARCHAR2, serial_format VARCHAR2)

Which design has a serial format of AB-12-34?
SELECT design FROM table_name_46 WHERE serial_format = "ab-12-34"
SELECT "design" FROM "table_name_46" WHERE "ab-12-34" = "serial_format"