Understanding of reorder rate in 11/12 (sql, analyzing business metrics)

<PLEASE USE THIS TEMPLATE TO HELP YOU CREATE A GREAT POST!>

<Below this line, add a link to the EXACT exercise that you are stuck at.>

https://www.codecademy.com/courses/sql-analyzing-business-metrics/lessons/advanced-aggregates/exercises/reorder-rate?action=lesson_resume

<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>
if the reorder rate as defined in 11/12, is high, does it mean large no. of orders are make by same people, then it should present most of orders are reorder, right? it should be opposite to the defination.
<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>

```

Replace this line with your code.

<do not remove the three backticks above>

I was also confused when reading the explanation of reorder rate, and I am on your side. I think that is a mistake or typo in the explanation.

2 Likes

I agree that something is wrong here.

Say 20 different people ordered a product 1 time each (20 distinct orders, 20 distinct people). This would mean 100% first-time orders.

The number of people who made orders can’t be greater than the number of orders (20 people, 30 orders for example). So the only other option is more orders than people (say, 20 orders, 5 people), and this could mean one of two pretty opposite cases:

  1. 1 person ordered 16 times and the other 4 only once each (few people reordering (1 of 5))
  2. each person ordered 4 times (many people people reordering (5 of 5))

Both of these cases would have the same “reorder_ratio”, yet they’re opposites based on my understanding of the ratio. So I’m missing something or the exercise is wrong.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.