Top products in Sochi
3-way JOIN on orders × products × users + GROUP BY on unindexed users.city.
Query took 75.0 ms
| # | Product | Category | Orders | Qty sold | Revenue |
|---|---|---|---|---|---|
| 4717 | Water bottle music | music | 7 | 23 | $18,877.77 |
| 2575 | Mechanical keyboard beauty | beauty | 7 | 33 | $17,996.63 |
| 1157 | Backpack toys | toys | 7 | 24 | $16,897.10 |
| 2071 | Travel pillow music | music | 6 | 25 | $16,430.03 |
| 4795 | Sunglasses toys | toys | 5 | 21 | $16,127.38 |
| 3695 | Office chair electronics | electronics | 7 | 26 | $15,967.38 |
| 1041 | Cotton t-shirt garden | garden | 5 | 18 | $15,920.58 |
| 2568 | Action camera clothes | clothes | 7 | 28 | $15,897.79 |
| 590 | Water bottle home | home | 7 | 22 | $15,491.95 |
| 4912 | Smart watch clothes | clothes | 6 | 27 | $14,979.65 |
| 3222 | Travel pillow garden | garden | 6 | 21 | $14,695.93 |
| 3557 | Bluetooth speaker beauty | beauty | 4 | 17 | $14,526.54 |
| 391 | Smart watch food | food | 7 | 23 | $14,434.15 |
| 3587 | Plant pot auto | auto | 5 | 22 | $13,932.33 |
| 4481 | Running shoes garden | garden | 6 | 20 | $13,682.30 |
| 1479 | Sunglasses books | books | 7 | 26 | $13,651.15 |
| 4279 | Coffee mug sports | sports | 5 | 18 | $13,320.48 |
| 1956 | Power bank office | office | 5 | 20 | $13,244.55 |
| 4180 | Bluetooth speaker music | music | 6 | 22 | $13,197.61 |
| 3363 | Cotton t-shirt garden | garden | 4 | 19 | $13,070.00 |
rendered in 107.6 ms