Practice Interview Questions
| Question | Status |
|---|---|
Identify the review_text with the highest count of 'cool' votes. In case of a tie, select the first occurrence. Output both the business name and the review text associated with the highest number of 'cool' votes.
yelp_reviews table:
| Column Name | Description |
|---|---|
| business_name | Name of the business |
| review_id | Identifier of the review |
| user_id | Identifier of the user |
| stars | Number of stars |
| review_date | Date of the review |
| review_text |
Identify the review_text with the highest count of 'cool' votes. In case of a tie, select the first occurrence. Output both the business name and the review text associated with the highest number of 'cool' votes.
yelp_reviews table:
| Column Name | Description |
|---|---|
| business_name | Name of the business |
| review_id | Identifier of the review |
| user_id | Identifier of the user |
| stars | Number of stars |
| review_date | Date of the review |
| review_text |
| Text of the review |
| funny | Number of funny votes |
| useful | Number of useful votes |
| cool | Number of cool votes |
Example output:
| business_name | review_text | cool |
|---|---|---|
| Thai House | Damn... Helen Y beat me to the punch and got the FTR for this place! Oh well, I will say that she did a great job with her review - I think I was Tha | 7 |
| Text of the review |
| funny | Number of funny votes |
| useful | Number of useful votes |
| cool | Number of cool votes |
Example output:
| business_name | review_text | cool |
|---|---|---|
| Thai House | Damn... Helen Y beat me to the punch and got the FTR for this place! Oh well, I will say that she did a great job with her review - I think I was Tha | 7 |