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

5 votes206 views2 answers
To date oracle
SQL
2 votes281 views1 answer
Mariadb json select
SQL
0 vote311 views1 answer
Drop check command
SQL
0 vote202 views1 answer
On sql table data exists
SQL
0 vote222 views1 answer
Space not removing from column in sql
SQL
13 votes194 views6 answers
Current date sql
SQL
0 vote197 views1 answer
What alter does in db
SQL
5 votes288 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
2 votes209 views2 answers
Postgresql get table names
SQL
0 vote196 views1 answer
Mysql count number of occurrences in a column
SQL