Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| District         | Vacator                                        | Reason for change                              | Successor                      | Date successor seated    |
|:-----------------|:-----------------------------------------------|:-----------------------------------------------|:-------------------------------|:-------------------------|
| georgia 3rd      | vacant                                         | rep-elect washington poe declined the seat     | george w. towns ( d )          | seated january 5, 1846   |
| new jersey 2nd   | samuel g. wright ( w )                         | died july 30, 1845                             | george sykes ( d )             | seated november 4, 1845  |
| tennessee 8th    | joseph h. peyton ( w )                         | died november 11, 1845                         | edwin h. ewing ( w )           | seated ??????            |
| virginia 11th    | william taylor ( d )                           | died january 17, 1846                          | james mcdowell ( d )           | seated march 6, 1846     |
| florida at-large | edward c. cabell ( w )                         | lost contested election january 24, 1846       | william h. brockenbrough ( d ) | seated january 24, 1846  |
| new york 12th    | richard p. herrick ( w )                       | died june 20, 1846                             | thomas c. ripley ( w )         | seated december 17, 1846 |
| alabama 3rd      | william l. yancey ( d )                        | resigned september 1, 1846                     | james l. cottrell ( d )        | seated december 7, 1846  |
| alabama 7th      | felix g. mcconnell ( d )                       | died september 10, 1846                        | franklin w. bowdon ( d )       | seated december 7, 1846  |
| iowa at-large    | iowa admitted into the union december 28, 1846 | iowa admitted into the union december 28, 1846 | s. clinton hastings ( d )      | seated december 28, 1846 |

Question: How many date of successor seated is new jersey 2nd in the district?

table_id: 1-225205-4
label: SELECT COUNT("Date successor seated") FROM "table" WHERE "District" = "New Jersey 2nd"