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?

@lauratangwt

The below code ran. This was the issue ""

```{r}
"
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