Data Extraction from Table with a query

Things I have tried

I tried some dataview list with metadata but it’s not what I want to do

What I’m trying to do

I am trying to do a query on a table that a write. I write a markdown table to structure data, now in an other file I want to do a query on that table to extract some data. It’s possible?