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

7 votes319 views4 answers
What is my mysql version
SQL
1 vote332 views1 answer
Sql set auto increment back to 0
SQL
0 vote266 views1 answer
Jooq finding lastest value in table
SQL
0 vote339 views1 answer
Dual in db2
SQL
0 vote299 views1 answer
Mysql pv progres
SQL
11 votes311 views3 answers
Change column name sql server management studio
SQL
0 vote297 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote289 views1 answer
Soql more than today
SQL
0 vote314 views1 answer
Sql count null values in all columns
SQL
2 votes296 views1 answer
Oracle create directory
SQL