Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Coupon Usage Rate

Return the percentage of orders that used a coupon (coupon_code is not NULL), rounded to two decimals.

Table schema

Orders(id INT PRIMARY KEY, coupon_code VARCHAR(10) NULL)

Sample data

id | coupon_code
1 | SAVE10
2 | NULL
3 | SAVE20
4 | SAVE10

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.