murilozocca

Boa tarde Preciso somar a quantidade de entregas por cliente e o valor de compras por cliente Alguém poderia me ajudar? SELECT customers.email, customers.telefone_celular, customers.telefone_fixo, customers.nome, customers.sexo, customer_addresses.rua, customer_addresses.numero, customer_addresses.cep, customer_addresses.bairro, customer_addresses.cidade, customer_addresses.estado, customer_addresses.entrega, orders.total, (select sum(total) FROM orders) FROM customers INNER JOIN customer_addresses ON customers.id = customer_addresses.customer_id INNER JOIN orders ON customer_addresses.customer_id = customers.id;