In the first week after digital account opening went live, Compliance asks whether any customers have an open account but no passed KYC. You have an accounts table with customer ID and open date, and a KYC results table where each customer may have several checks, each with a status of passed, failed or pending. How would you find these customers in SQL?

数字开户上线第一周，合规问：有没有客户账户已经开了，但 KYC 还没通过？你有一张账户表，记录客户号和开户日期；还有一张 KYC 结果表，每个客户可能有多条核验记录，状态分为通过、失败和待定。你会怎么用 SQL 把这些客户找出来？