1import sqlite3
2
3# Connect to SQLite database
4connection = sqlite3.connect('your_database.db')
5cursor = connection.cursor()
6
7# Execute the SQL query
8query = '''
9SELECT customer_id, COUNT(visit_id) AS count_no_trans
10FROM Visits
11LEFT JOIN Transactions ON Visits.visit_id = Transactions.visit_id
12WHERE Transactions.transaction_id IS NULL
13GROUP BY customer_id;'''
14
15cursor.execute(query)
16rows = cursor.fetchall()
17
18# Output the results
19for row in rows:
20    print(f"customer_id: {row[0]}, count_no_trans: {row[1]}")
21
22# Close the connection
23connection.close()

using System.Data;
using System.Data.SQLite;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=your_database.db;Version=3;";
        using (SQLiteConnection connection = new SQLiteConnection(connectionString))
        {
            connection.Open();

            string query = "SELECT customer_id, COUNT(visit_id) AS count_no_trans FROM Visits WHERE NOT EXISTS (SELECT 1 FROM Transactions WHERE Visits.visit_id = Transactions.visit_id) GROUP BY customer_id;";
            using (SQLiteCommand command = new SQLiteCommand(query, connection))
            {
                using (SQLiteDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine($"customer_id: {reader["customer_id"]}, count_no_trans: {reader["count_no_trans"]}");
                    }
                }
            }
        }
    }
}