You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Capital One's marketing team is working on a project to analyze customer feedback from their feedback surveys.
The team sorted the words from the feedback into three different categories;
• short_comments
• mid_length_comments
• long_comments
The team wants to find comments that are not short and that come from social media. The output should include 'feedback_id,' 'feedback_text,' 'source_channel,' and a calculated category.
'''
select *
from customer_feedback
Where comment_category in ('mid_length_comments', 'long_comments');