/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

9 votes215 views5 answers
Laravel to sql
SQL
2 votes191 views4 answers
Duplicate record mysql
SQL
0 vote230 views1 answer
Mysql where sum > 0
SQL
0 vote185 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote197 views1 answer
What is delimiter in mysql
SQL
0 vote192 views2 answers
Create new table plsql
SQL
1 vote180 views1 answer
Nested if in mysql
SQL
0 vote200 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote275 views1 answer
Sintaxis SELECT sql
SQL
0 vote249 views1 answer
How to find unique element in sql
SQL