I can't seem to make SQL work on R studio

Hi everyone!

I’m currently trying to do the Guided Project: Answering Business Questions using SQL.

But I cant seem to connect SQL with R studio.

Could someone please help me overcome this issue?


The below code ran. This was the issue ""

WITH usa_tracks_sold AS 
    SELECT il.* FROM invoice_line il
    INNER JOIN invoice i ON il.invoice_id = i.invoice_id
    INNER JOIN customer c ON i.customer_id = c.customer_id
    WHERE c.country = 'USA'

1 Like