Where clause for child record apex

Select C1, C2 from A 
where 
ID in (Select ParentId from B where Status__c='Completed') 
and 
Id NOT IN (Select ParentId from Opportunity where Status__c <> 'Completed')

Source: salesforce.stackexchange.com

Similar codes

0 vote123 views1 answer
Select from 3 tables one is empty
SQL
0 vote123 views1 answer
Reading from right to left from string find first special characters in sql
SQL
22 votes137 views3 answers
Year format in date mysql
SQL
0 vote130 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote128 views1 answer
Codeigniter dbforge add index
SQL
0 vote120 views1 answer
Mysql identified by syntax error
SQL
0 vote163 views1 answer
Stop and start mysql
SQL
0 vote125 views1 answer
Oracle sql procedure return value
SQL
0 vote128 views1 answer
Mysql grant grant option
SQL
0 vote130 views1 answer
Vs 2019 connect to local mysql database
SQL