'Group results from tables connecting customerID with customer FistName

Good day, I am completely new to SQL and I have a question. I am using MySQL and I want to do the following:

Suppose I have the following tables: customer:

CustomerID (PK) | FirstName | LastName | PhoneNumer 1 | Sally |Smith | 345-345-4567 2 | Brandon |Harris |512-467-8306

transaction:

TransactionID (PK) | CustomerID | TotalPrice | DateOrdered
100 | 1 |200 | 12/17/2021 200 | 2 |300 | 12/18/2021

I want to have a query that groups all customers BY NAME and shows the total amount of money they spent.

mysqljoin


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Join the same table temporary table in MySQL

SQL placement join with student, friend, package

How can I delete rows from table A and table B if rows in table B don't exist

Using SQL to join tables with a junction table

pandas: merge (join) two data frames on multiple columns

How to select all fields from one table that contain a substring from any row in another column

Postgres Subquery - How to create ALIAS in object format from subqueries

data.table join with date

ORA-22806 (not an object or REF) on Join to a view

Joining two tables and getting values

Join two dataframes using the closest timestamp pyspark

How to do a Join and a Loop corectly using R

compare two tables having same column name but different date column names

Rationale of Rails 5 Join Table Generated Defaults

SQL using table from join in subqueries