Answer the question
In order to leave comments, you need to log in
How to group data based on another table?
Good day!
There was a task to group the data on the basis of other table.
Given 2 tables.
First (for each x, its pair of y is given):
Second:
In the end, you need to get the sum of Int by comparing/grouping x and y, as they are indicated in the first table. Moreover, there is not always a pair for x and y. That is, you need to get:
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question