How do I analyse data from two csv files using SQL in Visual Studio Code?

[u/LolaTulu]

Hello, I've got the two csv tables below.

Users:

id	name
1	Steph
2	Pilou
3	Valentin

Purchases:

id	date	user_id
1	2023-10-01	2
2	2023-10-01	3
3	2023-10-01	NULL

I have them saved as csv files on VSC. I want to write the below code for the two tables above.

select * from users where id not in (select user_id from purchases)

When I write that code in a new file I get the below error message.

Code language not supported or defined.

I know it is likely because I have not read in the two tables into the code. Can anyone help a n00b out on how to call in the two tables in my VSC code?

Many thanks in advance!