/SQL/Can you use a where clause for a child query

Can you use a where clause for a child query

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 vote394 views1 answer
How to print sql query
SQL
0 vote393 views1 answer
Yesql
SQL
0 vote394 views1 answer
Space not removing from column in sql
SQL
1 vote387 views1 answer
Mysql select row max date
SQL
0 vote391 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
2 votes382 views1 answer
Sql percentage with % rounded down
SQL
0 vote370 views1 answer
How to Remove milliseconds from Date time
SQL
5 votes353 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
5 votes376 views4 answers
Start postgres server
SQL
0 vote419 views1 answer
ALV GRID events
SQL