SQL query to elasticSearch query?

Mysql query :

SELECT
column_1,
date,
(
SUM(column_2) + SUM(column_3) + SUM(column_4) + SUM(column_5) + SUM(column_6) + SUM(column_7)
) AS sumOfColumns
FROM
table_name
WHERE date BETWEEN "2015-04-22" AND "2015-04-23"
GROUP BY column_1, date
ORDER BY column_1, date;

Can it be converted to ES query ?

@waqas_gt

Thanks