Interview Query

Creating Companies Table

Have you seen this question before?

Let’s say that you’re in charge of creating a new companies table at your new startup’s database. Your boss wants you to track all major companies that could be interesting leads for salespeople.

You’re given a huge list of scraped company names from many different websites with a few fields such as:

  • Name

  • No. of Employees

  • Industry

  • Location

  • Primary phone

  • Date Established

The scraped list may include duplicates and misspellings. How would you create a new production_companies table prioritizing correctness while also ensuring we do not include duplicates?

Next question: Always Excited Users
Loading comments