-- Optimal SQL Solution
SELECT 'bull' as word, 
       COUNT(*) as count_occurrences
FROM Files 
WHERE content REGEXP '\\bbull\\b'
UNION ALL
SELECT 'bear' as word,
       COUNT(*) as count_occurrences  
FROM Files
WHERE content REGEXP '\\bbear\\b';

/* C implementation (using POSIX regex) */
#include <stdio.h>
#include <stdlib.h>
#include <regex.h>
#include <string.h>

typedef struct {
    char word[10];
    int count;
} Result;

Result* countWordOccurrencesOptimal(char** filesData, int numFiles) {
    static Result results[2];
    regex_t bullRegex, bearRegex;
    int bullCount = 0, bearCount = 0;
    
    // Compile regex patterns
    regcomp(&bullRegex, "\\<bull\\>", REG_EXTENDED);
    regcomp(&bearRegex, "\\<bear\\>", REG_EXTENDED);
    
    for (int i = 0; i < numFiles; i++) {
        if (regexec(&bullRegex, filesData[i], 0, NULL, 0) == 0) {
            bullCount++;
        }
        if (regexec(&bearRegex, filesData[i], 0, NULL, 0) == 0) {
            bearCount++;
        }
    }
    
    // Clean up
    regfree(&bullRegex);
    regfree(&bearRegex);
    
    strcpy(results[0].word, "bull");
    results[0].count = bullCount;
    strcpy(results[1].word, "bear");
    results[1].count = bearCount;
    
    return results;
}