Chapter 5, Problem 16E

Explanation of Solution

Recursive SQL query:

with all_sub as

(

select subpart_id, part_id

from subpart

where part_id = 'P-100'

union all

select p.subpart_id, p.part_id

from subpart p

inner join all_sub s on p...