// SQL Solution - Basic JOIN approach
#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>

typedef struct {
    char age_bucket[10];
    char activity_type[10];
    double percentage;
} Result;

int snaps_analysis_basic(sqlite3* db, Result** results, int* count) {
    const char* sql = 
        "SELECT "
        "    age_bucket,"
        "    activity_type,"
        "    ROUND(100.0 * SUM(time_spent) / ("
        "        SELECT SUM(time_spent) "
        "        FROM Activities a2 "
        "        JOIN Age ag2 ON a2.user_id = ag2.user_id"
        "    ), 2) as percentage"
        "FROM Activities a"
        "JOIN Age ag ON a.user_id = ag.user_id"
        "GROUP BY age_bucket, activity_type"
        "ORDER BY age_bucket, activity_type;";
    
    sqlite3_stmt* stmt;
    int rc = sqlite3_prepare_v2(db, sql, -1, &stmt, NULL);
    
    if (rc != SQLITE_OK) {
        return rc;
    }
    
    *results = malloc(sizeof(Result) * 10);
    *count = 0;
    
    while (sqlite3_step(stmt) == SQLITE_ROW) {
        strcpy((*results)[*count].age_bucket, 
               (char*)sqlite3_column_text(stmt, 0));
        strcpy((*results)[*count].activity_type, 
               (char*)sqlite3_column_text(stmt, 1));
        (*results)[*count].percentage = sqlite3_column_double(stmt, 2);
        (*count)++;
    }
    
    sqlite3_finalize(stmt);
    return SQLITE_OK;
}