generate a c# program using codex davinci to query using natural language a transaction table with structure (id, transactiondate, amount, response, customer name) for financial analysis in csharp

main.cs
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;

namespace TransactionAnalyzer
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Enter your query: ");
            string query = Console.ReadLine();

            string connectionString = "Data Source=(local);Initial Catalog=TransactionDB;Integrated Security=True";
            string sqlQuery = "";

            if (query.ToLower().Contains("highest transaction"))
            {
                sqlQuery = "SELECT MAX(amount) FROM Transactions";
            }
            else if (query.ToLower().Contains("lowest transaction"))
            {
                sqlQuery = "SELECT MIN(amount) FROM Transactions";
            }
            else if (query.ToLower().Contains("average transaction"))
            {
                sqlQuery = "SELECT AVG(amount) FROM Transactions";
            }
            else if (query.ToLower().Contains("total amount by customer"))
            {
                sqlQuery = "SELECT customer name, SUM(amount) FROM Transactions GROUP BY customer name";
            }
            else
            {
                Console.WriteLine("Invalid Query!");
                return;
            }

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(sqlQuery, connection);
                connection.Open();

                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    Console.WriteLine(reader[0]);
                }
            }
        }
    }
}
1704 chars
55 lines