simple answer please.

Consider the relational schema part (part_id, name, cost) subpart (part_id, subpart_id, count) Write an SQL function using non-recursive SQL to find the total cost of part "P-100", including the costs of all its subparts. Be sure to take into account the fact that a part may have multiple occurrences of a subpart