Customers --------- CustomerID (Primary Key, AutoNumber) FirstName (Text) LastName (Text) Email (Text) 

Orders ------ OrderID (Primary Key, AutoNumber) CustomerID (Foreign Key, Number) OrderDate (Date/Time) TotalAmount (Currency) 

CustomerID | FirstName | LastName | Email ------------------------------------------- 1          | John      | Doe      | john.doe@example.com 2          | Jane      | Smith    | jane.smith@example.com 3          | Alice     | Johnson  | alice.johnson@example.com 

OrderID | CustomerID | OrderDate  | TotalAmount ----------------------------------------------- 1       | 1          | 2023-10-01 | 150.00 2       | 1          | 2023-10-15 | 200.00 3       | 2          | 2023-10-20 | 250.00 4       | 3          | 2023-10-22 | 300.00 

SELECT Customers.FirstName, Customers.LastName, Orders.OrderDate, Orders.TotalAmount FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID; 

FirstName | LastName | OrderDate  | TotalAmount ----------------------------------------------- John      | Doe      | 2023-10-01 | 150.00 John      | Doe      | 2023-10-15 | 200.00 Jane      | Smith    | 2023-10-20 | 250.00 Alice     | Johnson  | 2023-10-22 | 300.00 

SELECT Customers.FirstName, Customers.LastName, SUM(Orders.TotalAmount) AS TotalSpent FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID GROUP BY Customers.FirstName, Customers.LastName; 

FirstName | LastName | TotalSpent --------------------------------- John      | Doe      | 350.00 Jane      | Smith    | 250.00 Alice     | Johnson  | 300.00 

SELECT Customers.FirstName, Customers.LastName, Orders.TotalAmount FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Orders.TotalAmount > 200.00; 

FirstName | LastName | TotalAmount ---------------------------------- Jane      | Smith    | 250.00 Alice     | Johnson  | 300.00