Cities With Completed Trades — Robinhood SQL Question

Solving SQL Question asked by Robinhood

Suraj Mishra

·

Follow

2 min read

·

Oct 31, 2022

--

Share

Introduction

• In this article we will solve Cities with completed trades question which is asked by robinhood as per DataLemur website.

If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.

Question

• We have been given robinhood trades table that mainly consist of trade status along with other trade info such as price, quantity.
• We have also been given user table that provides user information along with location.

• Our objective is to provide output that consist of cities where maximum number of trades were made ( completed status ) in descending order.

Solution

• If we look at trades input , we will know right away that we need to count of incident where trades…