intermediate
Generate a SQL JOIN Query
Construct a SQL query to retrieve data from two related tables.
📝 Contenido del prompt
Write a SQL query to select the customer names and their total order amounts from a 'customers' table and an 'orders' table, joining them on customer_id. Include only customers who have placed orders.