Creating a question with an other question as a parameter

Hi to everyone. I’m new and I’m experimenting with Metabase.

I wonder if it’s able to execute a question where the SQL sentence requires a parameter that is the result of another question. For example: Q1 gives you all the ID products you have currently in your store. Q2 gives you the sum of sales for only the list of products contained in Q1.

In terms of SQL sentence it means Q1 having an IN clause, where the In clause retrieves Q2.

So, can I connect Q1 with Q2?

Thank you!