This assignment is about the MODE analytics "Understanding Search Functionality" problem. Here is the link for the details: https://community.modeanalytics.com/sql/tutorial/understanding-search-functionality/
The solution can be found here: https://modeanalytics.com/nehajain/reports/2e8a5239eb1e