MySQL
Store, cart and marketplace questions, answered from MySQL or MariaDB.
Dot writes MySQL queries for your questions and shows every one.
Ryan Ortiz9:41 AM
@Dot Which products get carted most but bought least this month?
1 reply
DotAPP9:42 AM
8 steps · 50s · Access Online
Linen throws: only 3% of cart adds become orders.
Sources: MySQL’s cart_items and orders.
Here is the data.
| Product | Cart adds | Orders |
|---|---|---|
| Linen throws | 2,400 | 74 |
| Ceramic lamps | 1,860 | 92 |
| Wool rugs | 1,310 | 88 |
Today
Ryan Ortiz9:41 AM
Dot Which products get carted most but bought least this month?
Dot9:42 AM
8 steps · 50s · Access online
Linen throws: only 3% of cart adds become orders.
Sources: MySQL’s cart_items and orders.
- Linen throws: 2,400 cart adds, 74 orders
- Ceramic lamps: 1,860 cart adds, 92 orders
- Wool rugs: 1,310 cart adds, 88 orders
Priya Shah9:41 AM
@Dot Do customers whose first order used a coupon spend less with us over six months?
1 reply
DotAPP9:42 AM
9 steps · 48s · Access Online
Yes: $46 less per customer over six months.
Sources: MySQL’s orders and coupons.
Chart
Today
Priya Shah9:41 AM
Dot Do customers whose first order used a coupon spend less with us over six months?
Dot9:42 AM
9 steps · 48s · Access online
Yes: $46 less per customer over six months.
Sources: MySQL’s orders and coupons.
Daniel Weber9:41 AM
@Dot Which sellers cancelled the most orders last month, by share?
1 reply
DotAPP9:42 AM
6 steps · 39s · Access Online
Three sellers cancelled over 8%, against a 1.9% average.
Source: MySQL’s seller_orders.
Here is the data.
| Seller | Cancelled | Orders |
|---|---|---|
| Brightlane Home | 11.4% | 820 |
| Kova Outdoor | 9.2% | 1,140 |
| Mira Studio | 8.3% | 460 |
Today
Daniel Weber9:41 AM
Dot Which sellers cancelled the most orders last month, by share?
Dot9:42 AM
6 steps · 39s · Access online
Three sellers cancelled over 8%, against a 1.9% average.
Source: MySQL’s seller_orders.
- Brightlane Home: 11.4% cancelled, 820 orders
- Kova Outdoor: 9.2% cancelled, 1,140 orders
- Mira Studio: 8.3% cancelled, 460 orders
More in Databases & spreadsheets
Snowflake
BigQuery
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MotherDuck
Connect your data.
Start for Free