Question: Write a SQL query to return the company, website, and the similarity score ( jaccard ) between company and website with an alias 'similarity _

Write a SQL query to return the company, website, and the similarity score (jaccard) between company and website with an alias 'similarity_score'. For similarity score computation, you may want to convert both the company and website to the same case to return case-insensitive similarity score. Round the similarity score to two decimal places. Return only rows where the similarity score is greater than 0.85 or less than 0.15. Sort the results by similarity score in descending order.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!