· 8 years ago · May 31, 2018, 07:54 AM
1SELECT c.id, SUM(p.amount*p.count) amont
2FROM orders o
3LEFT JOIN customers c ON o.customer_id = c.id
4LEFT JOIN products p ON o.order_id = p.order_id
5WHERE c.email LIKE '%gmail.com'
6 AND o.date > ADDDATE(CURDATE(), INTERVAL -14 day)
7GROUP BY c.id
8HAVING SUM(p.amount*p.count) > 1000