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:
|   Rank | Name                      | Birth date        | Death date        | Age (as of 1 February 2014)   | Place of death or residence   |
|-------:|:--------------------------|:------------------|:------------------|:------------------------------|:------------------------------|
|      1 | jiroemon kimura           | 19 april 1897     | 12 june 2013      | 116 years, 54 days            | japan                         |
|      2 | christian mortensen       | 16 august 1882    | 25 april 1998     | 115 years, 252 days           | united states [a ]            |
|      3 | emiliano mercado del toro | 21 august 1891    | 24 january 2007   | 115 years, 156 days           | puerto rico                   |
|      4 | mathew beard              | 9 july 1870       | 16 february 1985  | 114 years, 222 days           | united states                 |
|      5 | walter breuning           | 21 september 1896 | 14 april 2011     | 114 years, 205 days           | united states                 |
|      6 | yukichi chuganji          | 23 march 1889     | 28 september 2003 | 114 years, 189 days           | japan                         |
|      7 | joan riudavets            | 15 december 1889  | 5 march 2004      | 114 years, 81 days            | spain                         |
|      8 | fred hale                 | 1 december 1890   | 19 november 2004  | 113 years, 354 days           | united states                 |
|      9 | johnson parks             | 15 october 1884   | 17 july 1998      | 113 years, 275 days           | united states                 |
|     10 | tomoji tanabe             | 18 september 1895 | 19 june 2009      | 113 years, 274 days           | japan                         |
|     11 | john ingram mcmorran      | 19 june 1889      | 24 february 2003  | 113 years, 250 days           | united states                 |
|     12 | frederick frazier         | 27 january 1880   | 14 june 1993      | 113 years, 138 days           | united states                 |
|     13 | james sisnett             | 22 february 1900  | 23 may 2013       | 113 years, 90 days            | barbados                      |
|     14 | walter richardson         | 7 november 1885   | 25 december 1998  | 113 years, 48 days            | united states                 |
|     15 | henry allingham           | 6 june 1896       | 18 july 2009      | 113 years, 42 days            | united kingdom                |
|     16 | antonio todde             | 22 january 1889   | 3 january 2002    | 112 years, 346 days           | italy                         |
|     17 | moses hardy               | 6 january 1894    | 7 december 2006   | 112 years, 335 days           | united states                 |
|     18 | john evans                | 19 august 1877    | 10 june 1990      | 112 years, 295 days           | united kingdom                |
|     19 | george francis            | 6 june 1896       | 27 december 2008  | 112 years, 204 days           | united states                 |
|     20 | denzo ishizaki            | 20 october 1886   | 29 april 1999     | 112 years, 191 days           | japan                         |
|     21 | josep armengol            | 23 july 1881      | 20 january 1994   | 112 years, 181 days           | spain                         |
|     22 | giovanni frau             | 29 december 1890  | 19 june 2003      | 112 years, 172 days           | italy                         |
|     23 | john painter              | 20 september 1888 | 1 march 2001      | 112 years, 162 days           | united states                 |
|     24 | alphaeus philemon cole    | 12 july 1876      | 25 november 1988  | 112 years, 136 days           | united states                 |
|     25 | augusto moreira           | 6 october 1896    | 13 february 2009  | 112 years, 130 days           | portugal                      |
|     26 | george johnson            | 1 may 1894        | 30 august 2006    | 112 years, 121 days           | united states                 |
|     27 | salustiano sanchez        | 8 june 1901       | 13 september 2013 | 112 years, 97 days            | united states [b ]            |
|     28 | gengan tonaki             | 30 october 1884   | 24 january 1997   | 112 years, 86 days            | japan                         |
|     29 | tadanosuke hashimoto      | 27 april 1891     | 31 may 2003       | 112 years, 34 days            | japan                         |
|     30 | kumekichi tani            | 20 april 1891     | 12 may 2003       | 112 years, 22 days            | japan                         |
|     31 | james wiggins             | 15 october 1879   | 16 october 1991   | 112 years, 1 day              | united states                 |
|     32 | walter h. seward          | 13 october 1896   | 14 september 2008 | 111 years, 337 days           | united states                 |
|     33 | maurice floquet           | 25 december 1894  | 10 november 2006  | 111 years, 320 days           | france                        |
|     34 | james mccoubrey           | 13 september 1901 | 5 july 2013       | 111 years, 295 days           | united states [c ]            |
|     35 | john mosely turner        | 15 june 1856      | 21 march 1968     | 111 years, 280 days           | united kingdom                |
|     36 | hermann dörnemann         | 27 may 1893       | 2 march 2005      | 111 years, 279 days           | germany                       |
|     37 | antonio urrea             | 18 february 1888  | 15 november 1999  | 111 years, 270 days           | spain                         |
|     38 | arthur carter             | 5 october 1889    | 11 june 2001      | 111 years, 249 days           | united states                 |
|     39 | jan machiel reyskens      | 11 may 1878       | 7 january 1990    | 111 years, 241 days           | netherlands [d ]              |
|     40 | joe thomas                | 1 may 1875        | 14 december 1986  | 111 years, 227 days           | united states                 |
|     41 | james zackry              | 15 august 1881    | 14 march 1993     | 111 years, 211 days           | united states                 |
|     42 | tanekichi onishi          | 15 february 1900  | 11 september 2011 | 111 years, 208 days           | japan                         |
|     43 | kiyoshi igarashi          | 2 august 1897     | 23 february 2009  | 111 years, 205 days           | japan                         |
|     44 | herman smith-johannsen    | 15 june 1875      | 5 january 1987    | 111 years, 204 days           | norway                        |
|     45 | ernest pusey              | 5 may 1895        | 19 november 2006  | 111 years, 198 days           | united states                 |
|     46 | arturo licata             | 2 may 1902        | living            | 111years, 275days             | italy                         |
|     47 | thomas nelson, sr.        | 8 july 1895       | 9 january 2007    | 111 years, 185 days           | united states                 |
|     48 | jokichi ikarashi          | 26 january 1902   | 23 july 2013      | 111 years, 178 days           | japan                         |
|     49 | earl brush                | 17 july 1893      | 10 january 2005   | 111 years, 177 days           | united states                 |
|     50 | antonio de castro         | 6 january 1898    | 22 june 2009      | 111 years, 167 days           | portugal                      |
|     51 | sukesaburo nakanishi      | 15 march 1896     | 22 august 2007    | 111 years, 160 days           | japan                         |
|     52 | luther goding             | 1 july 1884       | 5 december 1995   | 111 years, 157 days           | united states                 |
|     53 | jan pieter bos            | 12 july 1891      | 15 december 2002  | 111 years, 156 days           | netherlands                   |
|     54 | emile fourcade            | 29 july 1884      | 29 december 1995  | 111 years, 153 days           | france [e ]                   |
|     55 | benjamin harrison holcomb | 3 july 1889       | 2 december 2000   | 111 years, 152 days           | united states                 |
|     56 | aarne arvonen             | 4 august 1897     | 1 january 2009    | 111 years, 150 days           | finland                       |
|     57 | george frederick ives     | 17 november 1881  | 12 april 1993     | 111 years, 146 days           | canada [f ]                   |
|     58 | jan goossenaerts          | 30 october 1900   | 21 march 2012     | 111 years, 143 days           | belgium                       |
|     59 | garland adair             | 30 july 1898      | 11 december 2009  | 111 years, 134 days           | united states                 |
|     60 | anders engberg            | 1 july 1892       | 6 november 2003   | 111 years, 128 days           | sweden                        |
|     61 | jack lockett              | 22 january 1891   | 25 may 2002       | 111 years, 123 days           | australia                     |
|     62 | henry hartmann            | 14 july 1894      | 10 november 2005  | 111 years, 119 days           | united states                 |
|     63 | shelby harris             | 31 march 1901     | 25 july 2012      | 111 years, 116 days           | united states                 |
|     64 | daniel guzmán-garcía      | 6 february 1897   | 21 may 2008       | 111 years, 105 days           | colombia                      |
|     65 | sadayoshi tanabe          | 20 october 1888   | 18 january 2000   | 111 years, 90 days            | japan                         |
|     66 | makaru nakanishi          | 15 december 1901  | 28 february 2013  | 111 years, 75 days            | japan                         |
|     67 | henry pfeiffer            | 22 march 1881     | 23 may 1992       | 111 years, 62 days            | united states                 |
|     68 | zachariah blackistone     | 16 february 1871  | 18 april 1982     | 111 years, 61 days            | united states                 |
|     69 | antonio baldo             | 6 july 1887       | 28 august 1998    | 111 years, 53 days            | italy                         |
|     70 | edward bernard            | 22 june 1889      | 11 august 2000    | 111 years, 50 days            | united states                 |
|     71 | francisco fernández       | 24 july 1901      | 7 september 2012  | 111 years, 45 days            | spain                         |
|     72 | norio kawada              | 25 april 1892     | 6 june 2003       | 111 years, 42 days            | japan                         |
|     73 | kama nakasone             | 23 november 1891  | 1 january 2003    | 111 years, 39 days            | japan                         |
|     74 | harry patch               | 17 june 1898      | 25 july 2009      | 111 years, 38 days            | united kingdom                |
|     75 | peter solum               | 3 may 1882        | 5 june 1993       | 111 years, 33 days            | united states                 |
|     76 | masao kaga                | 1 june 1902       | 26 june 2013      | 111 years, 25 days            | japan                         |
|     77 | giovanni ligato           | 18 february 1901  | 2 march 2012      | 111 years, 13 days            | italy                         |
|     78 | domenico minervino        | 10 may 1880       | 22 may 1991       | 111 years, 12 days            | italy                         |
|     79 | nijiro tokuda             | 10 june 1895      | 12 june 2006      | 111 years, 2 days             | japan                         |
|     80 | valentino stella          | 2 january 1886    | 1 january 1997    | 110 years, 365 days           | italy                         |
|     81 | giichi okumura            | 18 october 1896   | 13 october 2007   | 110 years, 360 days           | japan                         |
|     82 | charles shebanek          | 9 september 1883  | 27 august 1994    | 110 years, 352 days           | united states                 |
|     83 | antonio pierro            | 22 february 1896  | 8 february 2007   | 110 years, 351 days           | united states [g ]            |
|     84 | carl berner               | 27 january 1902   | 7 january 2013    | 110 years, 346 days           | united states [h ]            |
|     85 | gregory pandazes          | 15 january 1873   | 22 december 1983  | 110 years, 341 days           | united states [i ]            |
|     85 | eiju tsuru                | 4 february 1879   | 11 january 1990   | 110 years, 341 days           | japan                         |
|     87 | charlie nelson            | 21 september 1867 | 20 august 1978    | 110 years, 333 days           | united states                 |
|     87 | yoshio nakagawa           | 19 december 1901  | 16 november 2012  | 110 years, 333 days           | japan                         |
|     89 | masatake kinoshita        | 20 august 1897    | 17 july 2008      | 110 years, 332 days           | japan                         |
|     90 | linus reinhart            | 28 july 1892      | 14 june 2003      | 110 years, 321 days           | united states                 |
|     91 | lloyd myers               | 20 march 1892     | 1 february 2003   | 110 years, 318 days           | united states                 |
|     92 | frank ahmann              | 11 may 1889       | 22 march 2000     | 110 years, 316 days           | united states                 |
|     93 | leopold vietoris          | 4 june 1891       | 9 april 2002      | 110 years, 309 days           | austria                       |
|     94 | takashi hattori           | 12 march 1898     | 12 january 2009   | 110 years, 306 days           | japan                         |
|     95 | walter wilcox             | 1 november 1872   | 11 august 1983    | 110 years, 283 days           | united states                 |
|     96 | galo leoz                 | 22 april 1879     | 23 january 1990   | 110 years, 276 days           | spain                         |
|     97 | alexander imich           | 4 february 1903   | living            | 110years, 362days             | united states [j ]            |
|     98 | a.l.m.                    | 11 april 1879     | 1 january 1990    | 110 years, 265 days           | spain                         |
|     99 | gregorio merino           | 24 december 1886  | 9 september 1997  | 110 years, 259 days           | spain                         |
|    100 | hilliard hudson           | 23 february 1899  | 6 november 2009   | 110 years, 256 days           | united states                 |

Question: Which Age (as of 1 February 2014) has a Rank smaller than 9, and a Death date of 24 january 2007?

table_id: 2-17852990-1
label: SELECT "Age (as of 1 February 2014)" FROM "table" WHERE "Rank" < 9 AND "Death date" = "24 january 2007"