execute_query.py

from data_manager import DatabaseManager

db_manager = DatabaseManager()
query = "SELECT country, brand, `2025 Y`, product, cej FROM raw_nps_data WHERE country = 'Global' AND cej = 'Total' AND banner1 = 'Total' AND banner2 = 'Total' AND attribute = 'NPS' AND `2025 Y` IS NOT NULL ORDER BY `2025 Y` DESC LIMIT 20"

result = db_manager.execute_query(query)
print(result.to_json(orient='records'))