/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

10 votes180 views6 answers
Mysql delete duplicates
SQL
6 votes213 views2 answers
Mysqldump password in file
SQL
0 vote200 views1 answer
Postgresql in vs any performance
SQL
0 vote195 views1 answer
Search from comma separated values in sql server
SQL
0 vote231 views1 answer
Get foreign table names mysql
SQL
7 votes202 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote211 views1 answer
Sqlcmd no headers
SQL
0 vote195 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote204 views1 answer
Character count sql
SQL
6 votes203 views3 answers
What is where in sql
SQL