What do you want to know?
Describe the data you need — we’ll turn it into a query.
Results
25 rows
› View SQL
SELECT c.first_name, c.last_name, c.email, COUNT(o.id) AS orders_placed FROM customers c JOIN orders o ON o.customer_id = c.id GROUP BY c.id, c.first_name, c.last_name, c.email HAVING COUNT(o.id) >= 10 ORDER BY orders_placed DESC LIMIT 100
| First Name | Last Name | Orders Placed | |
|---|---|---|---|
| Austyn | Romaguera | austyn.romaguera.811@hotmail.com | 35 |
| Adelle | Koelpin | adelle.koelpin.215@yahoo.com | 33 |
| Delphine | Hegmann | delphine.hegmann.611@hotmail.com | 31 |
| Ceasar | McKenzie | ceasar.mckenzie.434@yahoo.com | 31 |
| Edmund | Homenick | edmund.homenick.178@gmail.com | 30 |
| Bennett | Heaney | bennett.heaney.381@hotmail.com | 29 |
| Cheyanne | Green | cheyanne.green.669@hotmail.com | 28 |
| Delilah | Grant | delilah.grant.952@yahoo.com | 28 |
| Amina | Glover | amina.glover.483@hotmail.com | 27 |
| Alvah | Bode | alvah.bode.068@hotmail.com | 26 |
| Brook | Ankunding | brook.ankunding.907@hotmail.com | 25 |
| Darion | Bergnaum | darion.bergnaum.302@gmail.com | 25 |
| Ashley | Batz | ashley.batz.966@hotmail.com | 24 |
| Chanelle | Goyette | chanelle.goyette.210@hotmail.com | 24 |
| Barton | Koch | barton.koch.823@hotmail.com | 22 |
| Alexandro | Hauck | alexandro.hauck.078@hotmail.com | 22 |
| Earnestine | Ryan | earnestine.ryan.788@hotmail.com | 22 |
| Cheyanne | Cronin | cheyanne.cronin.126@yahoo.com | 21 |
| Alf | Jerde | alf.jerde.962@yahoo.com | 20 |
| Daniella | Kreiger | daniella.kreiger.734@yahoo.com | 20 |
| Aaron | Heller | aaron.heller.346@yahoo.com | 19 |
| Cleta | Weimann | cleta.weimann.040@yahoo.com | 19 |
| Charlie | Prohaska | charlie.prohaska.933@yahoo.com | 17 |
| Ebony | Bernhard | ebony.bernhard.685@yahoo.com | 16 |
| Cordia | Daniel | cordia.daniel.660@hotmail.com | 15 |