You have two tables-the first table has data about the users and their friends, the second table has data about the users and the pages they have liked. Write an SQL query to make recommendations using pages that your friends liked. The query result should not recommend the pages that have already been liked by a user.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Science Interview Questions

What is data science? Also, list the differences between supervised and unsupervised learning.

0 Answers  


Name Methods to Calculate Distance Measure?

0 Answers  


Is macbook good for data science?

0 Answers  


What is the definition of the unit test?

0 Answers  


Define boltzmann machine

0 Answers  






What are Random Forests?

0 Answers  


What are limitations of DBSCAN?

0 Answers  


Give some situations where you will use an SVM over a RandomForest Machine Learning algorithm and vice-versa?

0 Answers  


Please explain the goal of a/b testing.

0 Answers  


Explain the role of activation function?

0 Answers  


What is meant by logistic regression?

0 Answers  


Explain recommender systems?

0 Answers  


Categories