How do they make the value of the number of goods for certain values ​​in filters?

Question

SQL

Good evening.
In filters, there is often a quantity of a product opposite a brand.
Is this number stored in a separate table or is it recalculated every time when querying the database and sent to the client?

Answer 1

recalculated. too many filter options to store them all