// SQL Query (Optimal Approach)
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql/mysql.h>

typedef struct {
    char* name;
    int success;
} QueryResult;

QueryResult findWinningCandidate(MYSQL* conn) {
    QueryResult result = {NULL, 0};
    
    const char* query = 
        "SELECT c.name "
        "FROM Vote v "
        "JOIN Candidate c ON v.candidateId = c.id "
        "GROUP BY c.id, c.name "
        "ORDER BY COUNT(*) DESC "
        "LIMIT 1";
    
    if (mysql_query(conn, query)) {
        printf("Query failed: %s\n", mysql_error(conn));
        return result;
    }
    
    MYSQL_RES* mysql_result = mysql_store_result(conn);
    if (!mysql_result) {
        printf("Failed to store result: %s\n", mysql_error(conn));
        return result;
    }
    
    MYSQL_ROW row = mysql_fetch_row(mysql_result);
    if (row && row[0]) {
        result.name = malloc(strlen(row[0]) + 1);
        strcpy(result.name, row[0]);
        result.success = 1;
    }
    
    mysql_free_result(mysql_result);
    return result;
}

// Helper function to free result
void freeQueryResult(QueryResult* result) {
    if (result->name) {
        free(result->name);
        result->name = NULL;
    }
    result->success = 0;
}

int main() {
    MYSQL* conn = mysql_init(NULL);
    
    if (!mysql_real_connect(conn, "localhost", "user", "pass", "db", 0, NULL, 0)) {
        fprintf(stderr, "Connection failed: %s\n", mysql_error(conn));
        return 1;
    }
    
    QueryResult result = findWinningCandidate(conn);
    
    if (result.success) {
        printf("Winning candidate: %s\n", result.name);
        freeQueryResult(&result);
    } else {
        printf("No winner found\n");
    }
    
    mysql_close(conn);
    return 0;
}