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 users u
JOIN courses c ON c.instructor_id = u.user_id
JOIN enrollments e ON e.course_id = c.course_id
JOIN payments p ON p.enrollment_id = e.enrollment_id
GROUP BY u.name
ORDER BY total_earnings DESC;