Week 139 – Basic

AI galore!

Every week there’s something new coming from Cortex – and this week, we’ll be using the new ENTITY_SENTIMENT() function.

Professor Frosty’s training programme has been going from strength to strength thanks to these WONDERFUL reviews!

create or replace stage frosty_stage
    url = 's3://frostyfridaychallenges/'
;

create or replace table week_139 as 
select
    $1 as id,
    $2 as student,
    $3 as rating,
    $4 as review_text
from
    @frosty_stage/challenge_139 (
        file_format=>'frosty_csv'
    )
;

Now, it is your job to figure out the sentiment for the following categories:

• Overall
• Content
• Teaching

And the result ought to look something like: