A data scientist is exploring transaction data from a chain of stores with several locations. The data includes store number, date of sale, and purchase amount.
If the data scientist wants to compare total monthly sales between stores, which two options would be good ways to aggregate the data? (Choose two.)
A . Find the sum of the transaction prices
B . Select the largest transaction amount by month and store
C . Write a GROUP BY query
D . Plot a time series plot of transaction amounts
E . Generate a pivot table
Answer: BD