数据库mysql语言的嵌套查询问题

Question

数据库表的结构如下：
customer: custkey name comment
lineitem:orderkey partkey comment
orders:orderkey custkey
part: partkey name
请问如何用双层 exists 嵌套查询至少购买过顾客“齐光远”购买过的全部零件的顾客姓名。

Answer 1

select name from customer where custkey exists (select custkey from orders where orderkey exists (select custkey from customer where name = '齐光远'))