B) Write a SQL query to create a pivot table that tracks total number of orders of each customer for each month. C) Write a SQL query to create a pivot table that tracks total amount of order of each customer for each month D) Write a SQL query to create a pivot table that tracks total number of Order Type for each month E) Write a SQL query to create a pivot table that tracks total number of order type for each customer for each month. CID 1 Amount($) 25 Order ID 1 2 3 2 Type Entertainment Book Home_Improve Book 55 110 Date 2016-01-01 2016-01-05 2016-01-09 2016-01-10 3 4 1 32 AC nic 1 B) Write a SQL query to create a pivot table that tracks total number of orders of each customer for each month. C) Write a SQL query to create a pivot table that tracks total amount of order of each customer for each month D) Write a SQL query to create a pivot table that tracks total number of Order Type for each month E) Write a SQL query to create a pivot table that tracks total number of order type for each customer for each month. CID 1 Amount($) 25 Order ID 1 2 3 2 Type Entertainment Book Home_Improve Book 55 110 Date 2016-01-01 2016-01-05 2016-01-09 2016-01-10 3 4 1 32 AC nic 1