Suppose two tables are present. One is customer table and another one is Order. customer table contains CID, Name, Address and order table contains OrderID, CID, Value. So here CID is common to both table. Let us consider one customer having multiple values. Write a query to get customer name and total value for the last month of a single customer.