CREATE TABLE table_74566 ("Area" CLOB, "Advertisement date" CLOB, "Block" CLOB, "Winning applicant" CLOB, "Ensemble name" CLOB)

Which Block does Northamptonshire Area have?
SELECT "Block" FROM table_74566 WHERE "Area" = 'northamptonshire'
SELECT "Block" FROM "table_74566" WHERE "Area" = 'northamptonshire'