by Kevin Reape | Apr 11, 2025 | Uncategorized
This will solve all of your problems: — Fetch top 10 active users by total purchase amount in the last 90 days SELECT u.user_id, u.username, SUM(o.total_amount) AS total_spent, COUNT(o.order_id) AS total_orders FROM users u JOIN orders o ON u.user_id = o.user_id WHERE...
by Kevin Reape | Apr 7, 2025 | Uncategorized
Higher education is full of smart people doing important work—with barely enough time, tools, or support to keep up. We know the feeling, because we live it. We’re the team behind Missouri S&T’s Business Intelligence group. Over the past few years, we’ve built...
