import java.sql.*;

public class GetVillainsNames {
    private static final String URL = "jdbc:mysql://localhost:3306/minions_db";
    private static final String USER = "root";
    private static final String PASSWORD = "1234";

    public static void main(String[] args) {
        String query  =
                "SELECT v.name, COUNT(vm.villain_id) AS minions_count FROM villains AS v" +
                "INNER JOIN villains_minions AS vm" +
                "ON v.id = vm.villain_id" +
                "GROUP BY v.id";

        try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);
             Statement statement = connection.createStatement();
             ResultSet result = statement.executeQuery(query)){

            while (result.next()){
                String name = result.getString("name");
                int count = result.getInt("minions_count");
                System.out.printf("Name: %s, Count: %d\n", name, count);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}