sheets-db
GitHub repository
SQL query:
SELECT users.first_name , users.last_name , STRFTIME('%Y-%m-%d', users.birthday) AS birthday , transactions.category , SUM(transactions.price) AS total FROM users INNER JOIN transactions ON users.user_id = transactions.user_id GROUP BY users.user_id , transactions.category ORDER BY TOTAL DESC LIMIT 25
Execute SQL
SQL query output: