EASY MYSQL SOLUTION FOR BEGINNERS
please upvote :)\n\n# Code\n\nselect p.product_name, sum(o.unit) as unit\nfrom products p\nleft join orders o\non p.product_id = o.product_id\nwhere o.order_dat
please upvote :)\n\n# Code\n```\nselect p.product_name, sum(o.unit) as unit\nfrom products p\nleft join orders o\non p.product_id = o.product_id\nwhere o.order_date between \'2020-02-01\' and \'2020-02-29\'\ngroup by o.product_id\nhaving unit >= 100\norder by o.product_id;\n```
['MySQL']