How to calculate the number of parts lists and the total quantity of certain parts in these lists

Hello,

is it possible to calculate in sql, in how many BOMs (parts lists) in total is a component (part) present and how many pieces of this part are present in all these BOMs (parts lists) ?

The output should, if possible, look something like this:

select component_no(article_no), 

  total quantity of parts lists where the article occurs as component, 

   total quantity of this component in all these parts lists

from parts_table

where some_condition

There is a BOM_table (part, component, quantity of component) also.

Maybe to get the two quantities one needs 2 database functions that receive the component_no as parameter?