Your local fruit shop hired a bad programmer to build a system for tracking the sales of fruits. However, the programmer fled after implementing the system partially. With the system that the programmer wrote, the owner of the shop only tracks the sales of fruits on each date. But, the owner wants to know the total number of monthly sales for each fruit reported on the last day of each month. Can you help him to write a query that he can run to find out these information?
Input
You will be given a table product the following columns:
item:TEXTdate:DATEcount:BIGINT
You can assume that the composite fields (item, date) will be unique. There will be less than 2000 rows in this table.
Output
Your program needs to output a set with the following columns:
item:TEXTdate:DATEcount:BIGINT
Here, item is the column for fruits, date is the last date of each month found in the input table, and count is the total number of fruits sold on the corresponding month.
The rows should be sorted by item in alphabetic order and then the date in increasing order.
Sample
| item (TEXT) | date (DATE) | count (BIGINT) |
|---|---|---|
| coconut | 2019-01-01 | 2 |
| grape | 2019-01-01 | 2127 |
| coconut | 2019-01-02 | 294 |
| coconut | 2019-01-09 | 4 |
| banana | 2019-01-09 | 2 |
| grape | 2019-01-09 | 1676 |
| coconut | 2019-01-23 | 150 |
| grape | 2019-01-23 | 2701 |
| coconut | 2019-01-24 | 11 |
| coconut | 2019-02-20 | 2 |
| grape | 2019-02-24 | 151 |
| grape | 2019-02-25 | 1499 |
| orange | 2019-04-30 | 377 |
| mango | 2019-04-30 | 1127 |
| apple | 2019-05-02 | 375 |
| grape | 2019-07-08 | 1500 |
| coconut | 2019-07-09 | 302 |
| grape | 2019-07-09 | 1810 |
| apple | 2019-11-26 | 149 |
| coconut | 2019-11-26 | 56 |
| banana | 2019-11-26 | 189 |
| grape | 2020-03-15 | 1 |
| mango | 2020-03-15 | 2513 |
| grape | 2020-03-16 | 4280 |
| grape | 2020-09-13 | 775 |
| grape | 2020-09-15 | 3688 |
| grape | 2020-09-17 | 2528 |
| grape | 2020-12-21 | 1316 |
| mango | 2020-12-21 | 576 |
| coconut | 2020-12-23 | 1 |
| item (TEXT) | date (DATE) | count (BIGINT) |
|---|---|---|
| apple | 2019-05-31 | 375 |
| apple | 2019-11-30 | 149 |
| banana | 2019-01-31 | 2 |
| banana | 2019-11-30 | 189 |
| coconut | 2019-01-31 | 461 |
| coconut | 2019-02-28 | 2 |
| coconut | 2019-07-31 | 302 |
| coconut | 2019-11-30 | 56 |
| coconut | 2020-12-31 | 1 |
| grape | 2019-01-31 | 6504 |
| grape | 2019-02-28 | 1650 |
| grape | 2019-07-31 | 3310 |
| grape | 2020-03-31 | 4281 |
| grape | 2020-09-30 | 6991 |
| grape | 2020-12-31 | 1316 |
| mango | 2019-04-30 | 1127 |
| mango | 2020-03-31 | 2513 |
| mango | 2020-12-31 | 576 |
| orange | 2019-04-30 | 377 |
Notes
Do not include a date if there was no record for the corresponding month.