Skip to content
🤔 AI effective tips collection 🧠
question:Instruction: Compose the SQL query based on the input table and question given. If necessary, include 'table' as the table name for better understanding. Return the final result as JSON in the format {"SQL": "<SQL code>"}.[Q]:Input table:|Date|Visitor|Score|Home|Decision|Attendance||---|---|---|---|---|---||May 22|Colorado|2–1|Dallas|Belfour|17,001||May 24|Colorado|2–4|Dallas|Belfour|17,001||May 26|Dallas|3–0|Colorado|Belfour|16,061||May 28|Dallas|2–3|Colorado|Belfour|16,061||May 30|Colorado|7–5|Dallas|Belfour|17,001|Question:What is the lowest number of people attending the game on May 30 with Colorado as the visitors?Return the final result as JSON in the format {"SQL": "<SQL code>"}.[A]:

answer:{"SQL": "SELECT MIN `Attendance` FROM table WHERE `Visitor` = colorado AND `Date` = may 30"}

question:Description: Please identify the matching columns between Table A and Table B. For each column in Table A, specify the corresponding column in Table B. If a column in A has no corresponding column in Table B, you can map it to None. Represent each column mapping using a pair of column headers in a list, i.e., [Table A Column, Table B column or None]. Provide the mapping for each column in Table A and return all mappings in a list. Return the final result as JSON in the format {"column_mappings": "<a list of column pairs>"}.Input:Table A:|Type|Composition||---|---||Kriti|O jagadambA nannu brOvu|Table B:|Melody|Vernacular|Rhythm||---|---|---||kaLyANi|Telugu|Adi||rIti gouLa]|Telugu|misRa chApu|Return the final result as JSON in the format {"column_mappings": "<a list of column pairs>"}.Output:

answer:{"column_mappings": [["Type", "None"], ["Composition", "None"]]}

question:Objective: You must provide the missing data in the input table, denoted with '[MISSING]'. Only the filled-in value is required, not the complete table. Return the final result as JSON in the format {"value": "<value filled in>"}.Q:|MD1|2R1|MD4|Rank|Team|MD2|MD3|MD6|2R2|Total|Player|MD5||---|---|---|---|---|---|---|---|---|---|---|---||nan|nan|1.0|1|Al-Ain|2.0|nan|1.0|2.0|7|Omar Abdulrahman|1.0||1.0|1.0|nan|2|Shanghai SIPG|1.0|1.0|nan|1.0|6|Hulk|1.0||nan|1.0|1.0|2|[MISSING]|1.0|nan|1.0|1.0|6|Kaveh Rezaei|1.0||nan|nan|nan|2|Persepolis|2.0|1.0|3.0|nan|6|Mehdi Taremi|nan||1.0|nan|nan|4|Guangzhou Evergrande|1.0|1.0|nan|nan|5|Alan|2.0|Return the final result as JSON in the format {"value": "<value filled in>"}.A:

answer:{"value": "Esteghlal"}

question:Description: Please swap the fourth row and the third row in the table. Please return the table after swapping.## Input:|Series number|Filter size|Adapter ring||---|---|---||138|138 mm|nan||7.5|57.0 mm|nan||103|103 mm|nan||93|93 mm|nan||8.5/5.5L|74.8 mm x 5.6 mm|nan|## Output:|Series number|Filter size|Adapter ring||---|---|---||138|138 mm|nan||7.5|57.0 mm|nan||93|93 mm|nan||103|103 mm|nan||8.5/5.5L|74.8 mm x 5.6 mm|nan|## Input:|Series number|Filter size|Adapter ring||---|---|---||IV|20.6 mm|23.5 mm||4.5|25.5 mm|nan||V|30.2 mm|33.5 mm||5.5|35.9 mm|nan||VI|41.3 mm|44 mm|## Output:

answer:|Series number|Filter size|Adapter ring||---|---|---||IV|20.6 mm|23.5 mm||4.5|25.5 mm|nan||5.5|35.9 mm|nan||V|30.2 mm|33.5 mm||VI|41.3 mm|44 mm|

question:Objective: Here's a table for your consideration; please offer a summary of its key findings. Return the final result as JSON in the format {"summary": "<summary of table>"}.## Input:|Meet|Men(Winner)|Men(Nationality)|Men(Time)|Women(Winner)|Women(Nationality)|Women(Time)||---|---|---|---|---|---|---||Moscow|Camille Lacourt|France|24.67|Emily Seebohm|Australia|27.90||Chartres-Paris|Camille Lacourt|France|24.75|Natalie Coughlin|United States|27.65||Hong Kong|Ashley Delaney|Australia|25.55|Emily Seebohm|Australia|27.90||Beijing|Xu Jiayu|China|24.65|Fu Yuanhui|China|27.55||Singapore|Ashley Delaney|Australia|25.3|Cancelled|Cancelled|Cancelled|## Output:{"summary": "2015 FINA Swimming World Cup"}## Input:|Character|Portrayed by|Season(1)|Season(2)|Season(3)|Season(4)|Season(5)||---|---|---|---|---|---|---||Donald Blythe|Reed Birney|Recurring|Recurring|Recurring|Recurring|Recurring||Bob Birch|Larry Pine|Recurring|Recurring|Recurring|Recurring|Recurring||Terry Womack|Curtiss Cook|Recurring|Recurring|Recurring|Recurring|Recurring||Freddy Hayes|Reg E. Cathey|Recurring|Recurring|Recurring|Guest|nan||Michael Kern|Kevin Kilner|Recurring|Recurring|Recurring|nan|nan|Return the final result as JSON in the format {"summary": "<summary of table>"}.## Output:

answer:{"summary": "List of House of Cards characters"}

question:Task: I request that you perform a sorting operation on the table using column "County" in alphabetical descending order. Share the updated table with the sorted values.Input:|County|Jefferson %|Jefferson #|Pinckney %|Pinckney #|Total||---|---|---|---|---|---||Adams|45.41%|208|54.59%|250|458||Allegheny|100.00%|526|0.00%|0|526||Beaver|100.00%|202|0.00%|0|202||Bedford|90.62%|174|9.38%|18|192||Berks|97.20%|2,779|2.80%|80|2,859|Output:

answer:|County|Jefferson %|Jefferson #|Pinckney %|Pinckney #|Total||---|---|---|---|---|---||Berks|97.20%|2,779|2.80%|80|2,859||Bedford|90.62%|174|9.38%|18|192||Beaver|100.00%|202|0.00%|0|202||Allegheny|100.00%|526|0.00%|0|526||Adams|45.41%|208|54.59%|250|458|

Released under the MIT License.

has loaded