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:
| Year (Ceremony)   | Film title used in nomination              | Original title                                               | Director                                          | Result                 |
|:------------------|:-------------------------------------------|:-------------------------------------------------------------|:--------------------------------------------------|:-----------------------|
| 1951 (24th)       | rashomon                                   | rashōmon ( 羅生門 ? )                                        | akira kurosawa category:articles with hcards      | won honorary award     |
| 1954 (27th)       | gate of hell                               | jigokumon ( 地獄門 ? )                                       | teinosuke kinugasa category:articles with hcards  | won honorary award     |
| 1955 (28th)       | samurai, the legend of musashi             | miyamoto musashi ( 宮本武蔵 ? )                              | hiroshi inagaki category:articles with hcards     | won honorary award     |
| 1956 (29th)       | harp of burma                              | biruma no tategoto ( ビルマの竪琴 ? )                        | kon ichikawa category:articles with hcards        | nominee                |
| 1957 (30th)       | aruse                                      | arakure ( あらくれ ? )                                       | mikio naruse category:articles with hcards        | not nominated          |
| 1958 (31st)       | the ballad of narayama                     | narayama bushiko ( 楢山節考 ? )                              | keisuke kinoshita category:articles with hcards   | not nominated          |
| 1959 (32nd)       | fires on the plain                         | nobi ( 野火 ? )                                              | kon ichikawa category:articles with hcards        | not nominated          |
| 1960 (33rd)       | late autumn                                | akibiyori ( 秋日和 ? )                                       | yasujirō ozu category:articles with hcards        | not nominated          |
| 1961 (34th)       | immortal love                              | eien no hito ( 永遠の人 ? )                                  | keisuke kinoshita category:articles with hcards   | nominee                |
| 1962 (35th)       | being two isn't easy                       | watashi wa ni sai ( 私は二歳 ? )                             | kon ichikawa category:articles with hcards        | not nominated          |
| 1963 (36th)       | twin sisters of kyoto                      | koto ( 古都 ? )                                              | noboru nakamura category:articles with hcards     | nominee                |
| 1964 (37th)       | woman in the dunes                         | suna no onna ( 砂の女 ? )                                    | hiroshi teshigahara category:articles with hcards | nominee                |
| 1965 (38th)       | kwaidan                                    | kaidan ( 怪談 ? )                                            | masaki kobayashi category:articles with hcards    | nominee                |
| 1966 (39th)       | lake of tears                              | mizūmi no kin ( 湖の琴 ? )                                   | tomotaka tasaka category:articles with hcards     | not nominated          |
| 1967 (40th)       | portrait of chieko                         | chieko-sho ( 智恵子抄 ? )                                    | noboru nakamura category:articles with hcards     | nominee                |
| 1968 (41st)       | the sands of kurobe                        | kurobe no taiyō ( 黒部の太陽 ? )                             | kei kumai category:articles with hcards           | not nominated          |
| 1969 (42nd)       | kuragejima, legends from a southern island | kamigami no fukaki yokubō ( 神々の深き欲望 ? )               | shōhei imamura category:articles with hcards      | not nominated          |
| 1970 (43rd)       | the scandalous adventures of buraikan      | buraikan ( 無頼漢 ? )                                        | masahiro shinoda category:articles with hcards    | not nominated          |
| 1971 (44th)       | dodes'ka-den                               | dodes'ka-den ( どですかでん ? )                              | akira kurosawa category:articles with hcards      | nominee                |
| 1972 (45th)       | under the flag of the rising sun           | gunki hatameku moto ni ( 軍旗はためく下に, ? )               | kinji fukasaku category:articles with hcards      | not nominated          |
| 1973 (46th)       | coup d'etat                                | kaigenrei ( 戒厳令 ? )                                       | yoshishige yoshida category:articles with hcards  | not nominated          |
| 1974 (47th)       | the fossil                                 | kaseki ( 化石 ? )                                            | masaki kobayashi category:articles with hcards    | not nominated          |
| 1975 (48th)       | sandakan no. 8                             | sandakan hachibanshokan bohkyo ( サンダカン八番娼館 望郷 ? ) | kei kumai category:articles with hcards           | nominee                |
| 1977 (50th)       | mt. hakkoda                                | hakkōda-san ( 八甲田山 ? )                                   | shiro moritani category:articles with hcards      | not nominated          |
| 1978 (51st)       | empire of passion                          | ai no bōrei ( 愛の亡霊 ? )                                   | nagisa oshima category:articles with hcards       | not nominated          |
| 1979 (52nd)       | gassan                                     | gassan ( 月山 ? )                                            | tetsutaro murano category:articles with hcards    | not nominated          |
| 1980 (53rd)       | kagemusha (the shadow warrior)             | kagemusha ( 影武者 ? )                                       | akira kurosawa category:articles with hcards      | nominee                |
| 1981 (54th)       | muddy river                                | doro no kawa ( 泥の河 ? )                                    | kōhei oguri category:articles with hcards         | nominee                |
| 1982 (55th)       | onimasa                                    | kiryūin hanako no shōgai ( 鬼龍院花子の生涯 ? )              | hideo gosha category:articles with hcards         | not nominated          |
| 1983 (56th)       | antarctica                                 | nankyoku monogatari ( 南極物語 ? )                           | koreyoshi kurahara category:articles with hcards  | not nominated          |
| 1984 (57th)       | macarthur's children                       | setouchi shōnen yakyū-dan ( 瀬戸内少年野球団 ? )             | masahiro shinoda category:articles with hcards    | not nominated          |
| 1985 (58th)       | gray sunset                                | hanaichimonme ( 花いちもんめ ? )                             | shunya ito category:articles with hcards          | not nominated          |
| 1986 (59th)       | final take                                 | kinema no tenchi ( キネマの転地 ? )                          | yoji yamada category:articles with hcards         | not nominated          |
| 1987 (60th)       | zegen                                      | zegen ( 女衒 ? )                                             | shōhei imamura category:articles with hcards      | not nominated          |
| 1988 (61st)       | hope and pain                              | dauntaun hiirōzu ( ダウンタウン・ヒーローズ ? )              | yoji yamada category:articles with hcards         | not nominated          |
| 1989 (62nd)       | rikyu                                      | rikyu ( 利休 ? )                                             | hiroshi teshigahara category:articles with hcards | not nominated          |
| 1990 (63rd)       | the sting of death                         | shi no toge ( 死の棘 ? )                                     | kôhei oguri category:articles with hcards         | not nominated          |
| 1991 (64th)       | rhapsody in august                         | hachigatsu no kyōshikyoku ( 八月の狂詩曲 ? )                 | akira kurosawa category:articles with hcards      | not nominated          |
| 1992 (65th)       | the oil-hell murder                        | onna ya abura jigoku ( 女殺油地獄 ? )                        | hideo gosha category:articles with hcards         | not nominated          |
| 1993 (66th)       | madadayo                                   | mādadayo ( まあだだよ ? )                                    | akira kurosawa category:articles with hcards      | not nominated          |
| 1994 (67th)       | pom poko                                   | heisei tanuki gassen ponpoko ( 平成狸合戦ぽんぽこ ? )        | isao takahata category:articles with hcards       | not nominated          |
| 1995 (68th)       | deep river                                 | fukai kawa ( 深い河 ? )                                      | kei kumai category:articles with hcards           | not nominated          |
| 1996 (69th)       | gakko ii                                   | gakkō ii ( 学校ii ? )                                        | yoji yamada category:articles with hcards         | not nominated          |
| 1997 (70th)       | princess mononoke                          | mononoke hime ( もののけ姫 ? )                               | hayao miyazaki category:articles with hcards      | not nominated          |
| 1998 (71st)       | begging for love                           | ai o kōhito ( 愛を乞う人 ? )                                 | hideyuki hirayama category:articles with hcards   | not nominated          |
| 1999 (72nd)       | poppoya                                    | tetsudōin ( 鉄道員 ? )                                       | yasuo furuhata category:articles with hcards      | not nominated          |
| 2000 (73rd)       | after the rain                             | ame agaru ( 雨あがる ? )                                     | takashi koizumi category:articles with hcards     | not nominated          |
| 2001 (74th)       | go                                         | go                                                           | isao yukisada category:articles with hcards       | not nominated          |
| 2002 (75th)       | out                                        | out                                                          | hideyuki hirayama category:articles with hcards   | not nominated          |
| 2003 (76th)       | the twilight samurai                       | tasogare seibei ( たそがれ清兵衛 ? )                         | yoji yamada category:articles with hcards         | nominee                |
| 2004 (77th)       | nobody knows                               | dare mo shiranai ( 誰も知らない ? )                          | hirokazu koreeda category:articles with hcards    | not nominated          |
| 2005: (78th)      | blood and bones                            | chi to hone ( 血と骨 ? )                                     | yoichi sai category:articles with hcards          | not nominated          |
| 2006 (79th)       | hula girls                                 | hura gāru ( フラガール ? )                                   | sang-il lee category:articles with hcards         | not nominated          |
| 2007 (80th)       | i just didn't do it                        | soredemo boku wa yatte nai ( それでもボクはやってない ? )    | masayuki suo category:articles with hcards        | not nominated          |
| 2008 (81st)       | departures                                 | okuribito ( おくりびと ? )                                   | yojiro takita category:articles with hcards       | won academy award      |
| 2009 (82nd)       | nobody to watch over me                    | dare mo mamotte kurenai ( 誰も守ってくれない ? )             | ryoichi kimizuka category:articles with hcards    | not nominated          |
| 2010 (83rd)       | confessions                                | kokuhaku ( 告白 ? )                                          | tetsuya nakashima category:articles with hcards   | made january shortlist |
| 2011 (84th)       | postcard                                   | ichimai no hagaki ( 一枚のハガキ ? )                         | kaneto shindō category:articles with hcards       | not nominated          |
| 2012 (85th)       | our homeland                               | kazoku no kuni ( 一かぞくのくに ? )                          | yong-hi yang category:articles with hcards        | not nominated          |
| 2013 (86th)       | the great passage                          | fune o amu ( 舟を編む ? )                                    | yuya ishii                                        | tbd                    |

Question: WHAT IS THE RESULT WITH FILM LAKE OF TEARS?

table_id: 2-17894703-1
label: SELECT "Result" FROM "table" WHERE "Film title used in nomination" = "lake of tears"