1// Java with JDBC
2import java.sql.*;
3
4public class Main {
5    public static void main(String[] args) {
6        String url = "jdbc:sqlite:your_database.db";
7        String query = "SELECT customer_id, COUNT(visit_id) AS count_no_trans FROM Visits LEFT JOIN Transactions ON Visits.visit_id = Transactions.visit_id WHERE Transactions.transaction_id IS NULL GROUP BY customer_id;";
8        
9        try (Connection conn = DriverManager.getConnection(url);
10             Statement stmt = conn.createStatement();
11             ResultSet rs = stmt.executeQuery(query)) {
12
13            while (rs.next()) {
14                System.out.println("customer_id: " + rs.getInt("customer_id") + ", count_no_trans: " + rs.getInt("count_no_trans"));
15            }
16        } catch (SQLException e) {
17            System.out.println(e.getMessage());
18        }
19    }
20}