SQL For Retrieving Specific Data

I am using Cluvio connected with a MySQL DB to show graphs of data. Data is of this nature: level (int), status (int), datepurchased (datetime), product (text) 0, 100, 2017-07-03 11:28:52, prod1 1, 102, 2017-06-23 23:29:35, prod2 4, 0, 2017-05-23 23:29:35, prod1 1, 102, 2017-06-23 23:29:35, prod2 0, 404, 2017-06-23 23:29:35, prod2 1, 404, 2017-06-23 23:29:35, prod2 3, 101, 2017-07-23 23:29:35, prod1 2, 101, 2017-06-23 23:29:35, prod1 etc. What I need is SQL written for the following reports: 1. The count per product for current month (I.e. prod1: 2, prod2: 2) 2. The count per product for current month (I.e. prod1: 1, prod2: 2) 3. The count per level for current month (I.e. 3: 1) 3. The count per level for previous month (I.e. 1: 2, 2: 1) 4. Total count for levels 1-10 for current month (I.e: 1) 5. Total count sold for levels 1-10 for previous month (I.e: 3) Product names change from month to month so that cannot be hard-coded. All queries need to include: where level is 1-10 and status is 100-110 Thanks!