File size: 1,533 Bytes
2d33eeb |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
few_shots = [
{'Question': "How many gel pens do we have left in blue color?",
'SQLQuery': "SELECT sum(stock_quantity) FROM pens WHERE type = 'Gel' AND color = 'Blue'",
'SQLResult': "Result of the SQL query",
'Answer': "85"},
{'Question': "How much is the total value of the inventory for all ballpoint pens?",
'SQLQuery': "SELECT SUM(price*stock_quantity) FROM pens WHERE type = 'Ballpoint'",
'SQLResult': "Result of the SQL query",
'Answer': "3542"},
{'Question': "If we apply a 15% discount to all fountain pens, how much revenue would our store generate?",
'SQLQuery': """SELECT SUM(price * stock_quantity * 0.85) FROM pens WHERE type = 'Fountain'""",
'SQLResult': "Result of the SQL query",
'Answer': "1632.45"},
{'Question': "How many books are there in the 'Science' genre?",
'SQLQuery': "SELECT sum(stock_quantity) FROM books WHERE genre = 'Science'",
'SQLResult': "Result of the SQL query",
'Answer': "120"},
{'Question': "How much revenue will our store generate if we sell all biography books today at a 10% discount?",
'SQLQuery': """SELECT SUM(price * stock_quantity * 0.90) FROM books WHERE genre = 'Biography'""",
'SQLResult': "Result of the SQL query",
'Answer': "2700"},
{'Question': "What is the total stock of rollerball pens in green color?",
'SQLQuery': "SELECT sum(stock_quantity) FROM pens WHERE type = 'Rollerball' AND color = 'Green'",
'SQLResult': "Result of the SQL query",
'Answer': "50"}
]
|