I want to work with arrays/tables, i.e. to create tables based on the main table after filtering the values in values combined ways.
In DAX or EXCEL, this is very nicely done with FILTER and SORT and then you can use MIN/MAX/RANKX to get the right values from the resulted array.
Is there something similar in SQL?
I think it gets quite messy if you have to run separate or subquery SELECT statements, store them in variables, etc.
What is the neatest practice?