Start of Month:
(LAST_DAY(NOW() - INTERVAL 1 MONTH) + INTERVAL 1 DAY)


Start of week:
DATE_ADD(now(), INTERVAL (DAYOFWEEK(now()) - 7) DAY)

Start of last week:
DATE_ADD(now(), INTERVAL (DAYOFWEEK(now()) - 14) DAY) 

Total calls from InsideSales
SELECT substr(date,1,10) as day, count(*) as total_calls
FROM call_details
WHERE date >= FIRST_DAY(Now())
GROUP BY day 

MySQL - Create a Row Number
Here's the template for a query to add a new column with row number to a table in a query.

SELECT t.*,  
@rownum := @rownum + 1 AS rowNumber
FROM Your_Table
(SELECT @rownum := 0) 

Did this answer your question?