Vendor with the highest refund rate

Another serious exercise from the life of an E-commerce store. Since you’re losing money for every refund (yep, transaction fee of a payment provider) it’s super important to work with vendors who produce high quality goods, otherwise you’ll be losing money on refunds. In this exercise you’ll find which vendors have the highest refund rate.

This data warehouse is inspired by an E-commerce website like Amazon.

Our E-commerce website allows vendors to sell items in multiple categories. Users can add as many items as they want to a cart and then purchase a cart with/without a discount code. Users also can return items and leave reviews.

Hi, it’s Anatoli, the author of SQL Habit.

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit is also a collection of Practice exercises (you’re looking at one atm) based on various datasets (E-commerce, Finance, etc). They’re meant to deepen your SQL and Data Analysis knowledge , prepare you for any challenge at work or a job interview.