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 vote213 views1 answer
Convert int to varchar sql
SQL
0 vote179 views1 answer
Mysql identified by syntax error
SQL
0 vote183 views1 answer
Run postgresql dump to csv
SQL
0 vote188 views1 answer
Sum values by month mariadb
SQL
0 vote205 views1 answer
Connect postgresql using a connection string
SQL
1 vote228 views1 answer
Opensuse restart MySQL
SQL
0 vote181 views1 answer
Python mysql query where
SQL
0 vote148 views2 answers
Avg() sql
SQL
0 vote244 views1 answer
Sql server sleep
SQL
0 vote181 views1 answer
Remove from table where
SQL