About the author
[X]
|--------------------+--------------------+--------------------|
|store_name |store_sales |store_updates |
|____________________+____________________+____________________|
|Hanks Hardware 2500 2009-01-01 00:00:00 |
|Santos SuperStore 750 2008-12-01 00:00:00 |
|Bobs Boutique 1250 2009-01-01 00:00:00 |
|Pattyïs Pantstore 1050 2008-12-15 00:00:00 |
|Hanks Hardware 2250 2008-01-01 00:00:00 |
+--------------------------------------------------------------+
SELECT store_name, SUM(store_sales)
FROM stores
GROUP BY store_name
HAVING SUM(store_sales > 1200)
|--------------------+--------------------|
|store_name |SUM(store_sales) |
|____________________+____________________|
|Bobs Boutique 1250 |
|Hanks Hardware 4750 |
+------------------------------------------+
There are no comments on this article.
If you have any question or just want to leave a message, just fill out the form below!
Your e-mail will not be visible in your post, it is for validation reasons only