Consider the table "Grocer "and write SQL queries for the tasks that follow:
Table: Charity
| Item_Id | ItemName | UnitPrice | Quantity (kg) | Date_Purchase |
| 1 | Rice | 52.50 | 80 | 2010-02-01 |
| 2 | Wheat | 25.40 | 50 | 2010-03-09 |
| 3 | Corn | 50.80 | 100 | 2010-03-11 |
| 4 | Semolina | 28.90 | 50 | 2010-01-15 |
(Unit Price is per kg. price)
(i) Display Item name, unit price along with Date of purchase for all the Items.
(ii) Display Item name along with Month (in number) when it was purchased for all the items.
(iii) Display Item name along with year in which it was purchased for all the items.
(iv) Display Item Id, Date of Purchase and day name of week (e.g. Monday) on which it was purchased for all the items.
(v) Display names of all the items that were purchased on Mondays or Tuesdays.
(vi) Display the day name of the week on which Rice was purchased.
(vii) Display the Item name and unit price truncated to integer value (no decimal digits) of all the items.
(viii) Display current date.
