Practice Vendor with the highest refund rate

Vendor with the highest refund rate

About the exercise

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.

💾  About the dataset

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

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.

Anatoli Makarevich, author of SQL Habit About SQL Habit

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.

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.