CREATE TABLE table_10875694_11 (title VARCHAR, product_no VARCHAR)

How many titles have the product number SCUS-97330?
SELECT COUNT(title) FROM table_10875694_11 WHERE product_no = "SCUS-97330"
SELECT COUNT("title") FROM "table_10875694_11" WHERE "SCUS-97330" = "product_no"