Input Tokens
0
Output Tokens
0
Duration
0
Cost
0
Context
Input
Who are the instructors making the most money from enrollments? Give me a list (instructor_name) and total earnings (total_earnings) sorted by their earnings please.Expected output
SELECT u.name as instructor_name, SUM(p.amount) AS total_earnings FROM payments p JOIN enrollments e ON p.enrollment_id = e.enrollment_id JOIN courses c ON e.course_id = c.course_id JOIN users u ON c.instructor_id = u.user_id GROUP BY u.name ORDER BY total_earnings DESC;Model output
SELECT u.name AS instructor_name,
SUM(p.amount) AS total_earnings
FROM payments p
JOIN enrollments e ON p.enrollment_id = e.enrollment_id
JOIN courses c ON e.course_id = c.course_id
JOIN users u ON c.instructor_id = u.user_id
WHERE u.role = 'instructor'
GROUP BY u.user_id, u.name
ORDER BY total_earnings DESC;