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 | Family   | Abbre­viation   | Constellation       |   Area (sq.deg.) |   Area (msr) | Per­cent­age   |   Right ascension (hm) | Decli­nation (dm)   | Quad   |
|-------:|:---------|:---------------|:--------------------|-----------------:|-------------:|:-------------|-----------------------:|:-------------------|:-------|
|      1 | her      | hya            | hydra               |         1302.84  |      396.869 | 3.16%        |                1136.73 | −1431.91           | sq2    |
|      2 | zod      | vir            | virgo               |         1294.43  |      394.305 | 3.14%        |                1324.39 | −0409.51           | sq3    |
|      3 | urs      | uma            | ursa major          |         1279.66  |      389.807 | 3.10%        |                1118.76 | +5043.27           | nq2    |
|      4 | per      | cet            | cetus               |         1231.41  |      375.109 | 2.99%        |                 140.1  | −0710.76           | sq1    |
|      5 | her      | her            | hercules            |         1225.15  |      373.201 | 2.97%        |                1723.16 | +2729.93           | nq3    |
|      6 | wat      | eri            | eridanus            |         1137.92  |      346.63  | 2.76%        |                 318.02 | −2845.37           | sq1    |
|      7 | per      | peg            | pegasus             |         1120.79  |      341.413 | 2.72%        |                2241.84 | +1927.98           | nq4    |
|      8 | urs      | dra            | draco               |         1082.95  |      329.886 | 2.63%        |                1508.64 | +6700.40           | nq3    |
|      9 | her      | cen            | centaurus           |         1060.42  |      323.023 | 2.57%        |                1304.27 | −4720.72           | sq3    |
|     10 | zod      | aqr            | aquarius            |          979.854 |      298.481 | 2.38%        |                2217.38 | −1047.35           | sq4    |
|     11 | her      | oph            | ophiuchus           |          948.34  |      288.881 | 2.30%        |                1723.69 | −0754.74           | sq3    |
|     12 | zod      | leo            | leo                 |          946.964 |      288.462 | 2.30%        |                1040.03 | +1308.32           | nq2    |
|     13 | urs      | boo            | boötes              |          906.831 |      276.237 | 2.20%        |                1442.64 | +3112.16           | nq3    |
|     14 | zod      | psc            | pisces              |          889.417 |      270.932 | 2.16%        |                  28.97 | +1341.23           | nq1    |
|     15 | zod      | sgr            | sagittarius         |          867.432 |      264.235 | 2.10%        |                1905.94 | −2828.61           | sq4    |
|     16 | her      | cyg            | cygnus              |          803.983 |      244.907 | 1.95%        |                2035.28 | +4432.70           | nq4    |
|     17 | zod      | tau            | taurus              |          797.249 |      242.856 | 1.93%        |                 442.13 | +1452.63           | nq1    |
|     18 | urs      | cam            | camelopardalis      |          756.828 |      230.543 | 1.83%        |                 851.37 | +6922.89           | nq2    |
|     19 | per      | and            | andromeda           |          722.278 |      220.018 | 1.75%        |                  48.46 | +3725.91           | nq1    |
|     20 | wat      | pup            | puppis              |          673.434 |      205.14  | 1.63%        |                 715.48 | −3110.64           | sq2    |
|     21 | per      | aur            | auriga              |          657.438 |      200.267 | 1.59%        |                 604.42 | +4201.68           | nq2    |
|     22 | her      | aql            | aquila              |          652.473 |      198.755 | 1.58%        |                1940.02 | +0324.65           | nq4    |
|     23 | her      | ser            | serpens             |          636.928 |      194.019 | 1.54%        |                1657.04 | +0607.32           | nq3    |
|     24 | per      | per            | perseus             |          614.997 |      187.339 | 1.49%        |                 310.5  | +4500.79           | nq1    |
|     25 | per      | cas            | cassiopeia          |          598.407 |      182.285 | 1.45%        |                 119.16 | +6211.04           | nq1    |
|     26 | ori      | ori            | orion               |          594.12  |      180.979 | 1.44%        |                 534.59 | +0556.94           | nq1    |
|     27 | per      | cep            | cepheus             |          587.787 |      179.05  | 1.42%        |                 232.64 | +7100.51           | nq4    |
|     28 | urs      | lyn            | lynx                |          545.386 |      166.134 | 1.32%        |                 759.53 | +4728.00           | nq2    |
|     29 | zod      | lib            | libra               |          538.052 |      163.9   | 1.30%        |                1511.96 | −1514.08           | sq3    |
|     30 | zod      | gem            | gemini              |          513.761 |      156.501 | 1.25%        |                 704.24 | +2236.01           | nq2    |
|     31 | zod      | cnc            | cancer              |          505.872 |      154.097 | 1.23%        |                 838.96 | +1948.35           | nq2    |
|     32 | wat      | vel            | vela                |          499.649 |      152.202 | 1.21%        |                 934.64 | −4710.03           | sq2    |
|     33 | zod      | sco            | scorpius            |          496.783 |      151.329 | 1.20%        |                1653.24 | −2701.89           | sq3    |
|     34 | wat      | car            | carina              |          494.184 |      150.537 | 1.20%        |                 841.7  | −6313.16           | sq2    |
|     35 | ori      | mon            | monoceros           |          481.569 |      146.694 | 1.17%        |                 703.63 | +0016.93           | nq2    |
|     36 | lac      | scl            | sculptor            |          474.764 |      144.621 | 1.15%        |                  26.28 | −3205.30           | sq1    |
|     37 | bay      | phe            | phoenix             |          469.319 |      142.963 | 1.14%        |                  55.91 | −4834.84           | sq1    |
|     38 | urs      | cvn            | canes venatici      |          465.194 |      141.706 | 1.13%        |                1306.96 | +4006.11           | nq3    |
|     39 | zod      | ari            | aries               |          441.395 |      134.457 | 1.07%        |                 238.16 | +2047.54           | nq1    |
|     40 | zod      | cap            | capricornus         |          413.947 |      126.095 | 1.00%        |                2102.93 | −1801.39           | sq4    |
|     41 | lac      | for            | fornax              |          397.502 |      121.086 | 0.96%        |                 247.88 | −3138.07           | sq1    |
|     42 | urs      | com            | coma berenices      |          386.475 |      117.727 | 0.94%        |                1247.27 | +2318.34           | nq3    |
|     43 | ori      | cma            | canis major         |          380.118 |      115.791 | 0.92%        |                 649.74 | −2208.42           | sq2    |
|     44 | bay      | pav            | pavo                |          377.666 |      115.044 | 0.92%        |                1936.71 | −6546.89           | sq4    |
|     45 | bay      | gru            | grus                |          365.513 |      111.342 | 0.89%        |                2227.39 | −4621.11           | sq4    |
|     46 | her      | lup            | lupus               |          333.683 |      101.646 | 0.81%        |                1513.21 | −4242.53           | sq3    |
|     47 | her      | sex            | sextans             |          313.515 |       95.502 | 0.76%        |                1016.29 | −0236.88           | sq2    |
|     48 | bay      | tuc            | tucana              |          294.557 |       89.727 | 0.71%        |                2346.64 | −6549.80           | sq4    |
|     49 | bay      | ind            | indus               |          294.006 |       89.559 | 0.71%        |                2158.33 | −5942.40           | sq4    |
|     50 | lac      | oct            | octans              |          291.045 |       88.657 | 0.71%        |                2300    | −8209.12           | sq4    |
|     51 | ori      | lep            | lepus               |          290.291 |       88.428 | 0.70%        |                 533.95 | −1902.78           | sq1    |
|     52 | her      | lyr            | lyra                |          286.476 |       87.266 | 0.69%        |                1851.17 | +3641.36           | nq4    |
|     53 | her      | crt            | crater              |          282.398 |       86.023 | 0.68%        |                1123.75 | −1555.74           | sq2    |
|     54 | wat      | col            | columba             |          270.184 |       82.303 | 0.65%        |                 551.76 | −3505.67           | sq1    |
|     55 | her      | vul            | vulpecula           |          268.165 |       81.688 | 0.65%        |                2013.88 | +2426.56           | nq4    |
|     56 | urs      | umi            | ursa minor          |          255.864 |       77.941 | 0.62%        |                1500    | +7741.99           | nq3    |
|     57 | lac      | tel            | telescopium         |          251.512 |       76.615 | 0.61%        |                1919.54 | −5102.21           | sq4    |
|     58 | lac      | hor            | horologium          |          248.885 |       75.815 | 0.60%        |                 316.56 | −5320.18           | sq1    |
|     59 | lac      | pic            | pictor              |          246.739 |       75.161 | 0.60%        |                 542.46 | −5328.45           | sq1    |
|     60 | wat      | psa            | piscis austrinus    |          245.375 |       74.745 | 0.59%        |                2217.07 | −3038.53           | sq4    |
|     61 | bay      | hyi            | hydrus              |          243.035 |       74.033 | 0.59%        |                 220.65 | −6957.39           | sq1    |
|     62 | lac      | ant            | antlia              |          238.901 |       72.773 | 0.58%        |                1016.43 | −3229.01           | sq2    |
|     63 | her      | ara            | ara                 |          237.057 |       72.212 | 0.57%        |                1722.49 | −5635.30           | sq3    |
|     64 | urs      | lmi            | leo minor           |          231.956 |       70.658 | 0.56%        |                1014.72 | +3208.08           | nq2    |
|     65 | wat      | pyx            | pyxis               |          220.833 |       67.27  | 0.54%        |                 857.16 | −2721.10           | sq2    |
|     66 | lac      | mic            | microscopium        |          209.513 |       63.821 | 0.51%        |                2057.88 | −3616.49           | sq4    |
|     67 | bay      | aps            | apus                |          206.327 |       62.851 | 0.50%        |                1608.65 | −7518.00           | sq3    |
|     68 | per      | lac            | lacerta             |          200.688 |       61.133 | 0.49%        |                2227.68 | +4602.51           | nq4    |
|     69 | wat      | del            | delphinus           |          188.549 |       57.435 | 0.46%        |                2041.61 | +1140.26           | nq4    |
|     70 | her      | crv            | corvus              |          183.801 |       55.989 | 0.45%        |                1226.52 | −1826.20           | sq3    |
|     71 | ori      | cmi            | canis minor         |          183.367 |       55.857 | 0.44%        |                 739.17 | +0625.63           | nq2    |
|     72 | bay      | dor            | dorado              |          179.173 |       54.579 | 0.43%        |                 514.51 | −5923.22           | sq1    |
|     73 | urs      | crb            | corona borealis     |          178.71  |       54.438 | 0.43%        |                1550.59 | +3237.49           | nq3    |
|     74 | lac      | nor            | norma               |          165.29  |       50.35  | 0.40%        |                1554.18 | −5121.09           | sq3    |
|     75 | lac      | men            | mensa               |          153.484 |       46.754 | 0.37%        |                 524.9  | −7730.24           | sq1    |
|     76 | bay      | vol            | volans              |          141.354 |       43.059 | 0.34%        |                 747.73 | −6948.07           | sq2    |
|     77 | bay      | mus            | musca               |          138.355 |       42.145 | 0.34%        |                1235.28 | −7009.66           | sq3    |
|     78 | per      | tri            | triangulum          |          131.847 |       40.163 | 0.32%        |                 211.07 | +3128.56           | nq1    |
|     79 | bay      | cha            | chamaeleon          |          131.592 |       40.085 | 0.32%        |                1041.53 | −7912.30           | sq2    |
|     80 | her      | cra            | corona australis    |          127.696 |       38.898 | 0.31%        |                1838.79 | −4108.85           | sq4    |
|     81 | lac      | cae            | caelum              |          124.865 |       38.036 | 0.30%        |                 442.27 | −3752.90           | sq1    |
|     82 | lac      | ret            | reticulum           |          113.936 |       34.707 | 0.28%        |                 355.27 | −5959.85           | sq1    |
|     83 | her      | tra            | triangulum australe |          109.978 |       33.501 | 0.27%        |                1604.95 | −6523.28           | sq3    |
|     84 | her      | sct            | scutum              |          109.114 |       33.238 | 0.26%        |                1840.39 | −0953.32           | sq4    |
|     85 | lac      | cir            | circinus            |           93.353 |       28.437 | 0.23%        |                1434.54 | −6301.82           | sq3    |
|     86 | her      | sge            | sagitta             |           79.932 |       24.349 | 0.19%        |                1939.05 | +1851.68           | nq4    |
|     87 | wat      | equ            | equuleus            |           71.641 |       21.823 | 0.17%        |                2111.26 | +0745.49           | nq4    |
|     88 | her      | cru            | crux                |           68.447 |       20.85  | 0.17%        |                1226.99 | −6011.19           | sq3    |

Question: What is the largest Area (msr) that has an Area less than 291.045, is part of the Per family, and has a rank higher than 78?

table_id: 2-177766-1
label: SELECT MAX("Area (msr)") FROM "table" WHERE "Area (sq.deg.)" < 291.045 AND "Family" = "per" AND "Rank" > 78