SELECT customer.customer_id,
customer.first_name,
customer.last_name,
SUM(invoice.total) as total
FROM `Music_database.customer`
JOIN `Music_database.invoice`
ON customer.customer_id = invoice.customer_id
GROUP BY customer.customer_id
ORDER BY total desc
limit 1
Getting this error: Unrecognized name: customer; Did you mean customer_id? at [7:4]
while running this code. Please help
LinkedIn
Twitter
