query("SELECT u.*, (SELECT COUNT(*) FROM orders WHERE user_id = u.id) as order_count, (SELECT COALESCE(SUM(total), 0) FROM orders WHERE user_id = u.id AND payment_status = 'completed') as total_spent FROM users u ORDER BY u.created_at DESC")->fetchAll(); ?>

All Customers ()

Customer	Email	Phone	Orders	Total Spent	Joined	Status