#261 Most Frequently Used Promocode

Companies:

Innotech

Themes:

SQLJoinsAggregationPractice

Write a query that returns all data about the promocode that was used most often in orders:

Orders
order_id | promocode_id
...

Promocodes
promocode_id | name | discount
...

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.