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:
| Res.   | Record    | Opponent                 | Method                          | Round   |
|:-------|:----------|:-------------------------|:--------------------------------|:--------|
| loss   | 55–10 (1) | kazuhiro nakamura        | decision (unanimous)            | 2       |
| loss   | 55–9 (1)  | alistair overeem         | submission (guillotine choke)   | 1       |
| win    | 55–8 (1)  | yuki kondo               | decision (unanimous)            | 3       |
| win    | 54–8 (1)  | yoshiki takahashi        | ko (punch)                      | 1       |
| win    | 53–8 (1)  | sergey terezimov         | submission (heel hook)          | n/a     |
| win    | 52–8 (1)  | katsuhisa fujii          | ko (punches)                    | 1       |
| win    | 51–8 (1)  | dan bobish               | tko (punches)                   | 2       |
| loss   | 50–8 (1)  | mirko filipovic          | ko (head kick)                  | 1       |
| win    | 50–7 (1)  | bob schrijber            | submission (rear naked choke)   | 2       |
| loss   | 49–7 (1)  | quinton jackson          | submission (injury)             | 1       |
| loss   | 49–6 (1)  | heath herring            | decision (unanimous)            | 3       |
| win    | 49–5 (1)  | valentijn overeem        | submission (heel hook)          | 1       |
| win    | 48–5 (1)  | ricardas rocevicius      | tko (low kicks)                 | 2       |
| loss   | 47–5 (1)  | mario sperry             | submission (arm-triangle choke) | 1       |
| win    | 47–4 (1)  | masaaki satake           | decision (unanimous)            | 3       |
| win    | 46–4 (1)  | gilbert yvel             | submission (rear naked choke)   | 1       |
| loss   | 45–4 (1)  | tra telligman            | decision (unanimous)            | 3       |
| win    | 45–3 (1)  | mark kerr                | decision (unanimous)            | 3       |
| win    | 44–3 (1)  | nobuhiko takada          | tko (punches)                   | 2       |
| win    | 43–3 (1)  | enson inoue              | tko (punches)                   | 1       |
| win    | 42–3 (1)  | daijiro matsui           | tko (cut)                       | 1       |
| loss   | 41–3 (1)  | mark coleman             | submission (knees)              | 2       |
| win    | 41–2 (1)  | kazushi sakuraba         | tko (corner stoppage)           | 1       |
| win    | 40–2 (1)  | gary goodridge           | tko (punches)                   | 1       |
| win    | 39–2 (1)  | alexander otsuka         | decision (unanimous)            | 1       |
| win    | 38–2 (1)  | francisco bueno          | ko (punches)                    | 1       |
| nc     | 37–2 (1)  | mark kerr                | nc (illegal knees)              | 2       |
| win    | 37–2      | carlos "carlão" barreto  | decision (unanimous)            | 3       |
| win    | 36–2      | vepcho bardanashvili     | submission (choke)              | 1       |
| win    | 35–2      | vladimir solodovnik      | tko (punches)                   | 1       |
| win    | 34–2      | akira shoji              | decision (unanimous)            | 2       |
| win    | 33–2      | edson carvalho           | tko (punches)                   | 1       |
| win    | 32–2      | aloisio freitas neto     | tko (punches)                   | 1       |
| win    | 31–2      | gary goodridge           | tko (punches)                   | 1       |
| win    | 30–2      | nick nutter              | ko (knee)                       | 1       |
| win    | 29–2      | elias rodrigues          | tko (headbutt & punches)        | 1       |
| win    | 28–2      | tulio palhares           | tko (punches)                   | 1       |
| win    | 27–2      | nick nutter              | tko (headbutts)                 | 1       |
| win    | 26–2      | mikhail avetisyan        | decision                        | 1       |
| win    | 25–2      | valery pliev             | tko (punches)                   | 1       |
| win    | 24–2      | yuri mildzikhov          | tko (forfeit)                   | 1       |
| win    | 23–2      | igor guerus              | tko (punches)                   | 1       |
| win    | 22–2      | vasily kudin             | tko (leg kicks)                 | 1       |
| win    | 21–2      | dimitry panfilov         | tko (punches)                   | n/a     |
| win    | 20–2      | aslan hamza              | ko                              | n/a     |
| win    | 19–2      | leonardo castello branco | decision (split)                | 1       |
| win    | 18–2      | igor akhmedov            | submission (choke)              | n/a     |
| win    | 17–2      | john dixson              | submission (exhaustion)         | 1       |
| win    | 16–2      | paul varelans            | ko (punches)                    | 1       |
| win    | 15–2      | fred floyd               | tko (punches)                   | 1       |
| win    | 14–2      | igor akhmedov            | submission (choke)              | 1       |
| win    | 13–2      | yuri zhernikov           | tko (punches)                   | 1       |
| win    | 12–2      | matrosov matrosov        | tko (punches)                   | 1       |
| win    | 11–2      | igor guerus              | ko (punches)                    | 1       |
| win    | 10–2      | sergey sheremet          | ko (punch)                      | 1       |
| win    | 9–2       | oleg tischenko           | ko (punch)                      | 1       |
| win    | 8–2       | roman tikunov            | ko (punch)                      | n/a     |
| win    | 7–2       | sergei bondarovich       | ko (head kick)                  | n/a     |
| win    | 6–2       | nikolai yatsuk           | ko (punch)                      | n/a     |
| loss   | 5–2       | mikhail ilyukhin         | submission (chin in the eye)    | 1       |
| win    | 5–1       | adilson lima             | tko (broken nose)               | 1       |
| win    | 4–1       | adilson lima             | tko (corner stoppage)           | 1       |
| win    | 3–1       | sergei akinen            | tko (broken arm)                | 1       |
| loss   | 2–1       | andrei besedin           | submission (kneebar)            | 1       |
| win    | 2–0       | sergei bondarovich       | ko (punches)                    | 1       |
| win    | 1–0       | alexander mandrik        | tko (punches)                   | 1       |

Question: Record of 47–5 (1) involved what res?

table_id: 2-1486687-2
label: SELECT "Res." FROM "table" WHERE "Record" = "47–5 (1)"