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