Looking for a sql conversion to laravel format for a program. Please, Convert the sql into format of laravel

SELECT (ch.category) AS category1,(product.category) AS category2 FROM (SELECT SUM(point), category FROM history GROUP BY category ASC) AS ch,product WHERE product.category IN (SELECT category FROM (SELECT SUM(point), category FROM history GROUP BY category ASC) AS ch)

I want to write this on the Controller file. Please find me a way out. Thank you.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2PpzsId
via IFTTT