/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

3 votes110 views1 answer
Mysql UPDate with enner join
SQL
12 votes104 views5 answers
Sql merge
SQL
7 votes146 views1 answer
Show line number in sql server
SQL
0 vote129 views1 answer
Mysql coonect sample code
SQL
2 votes125 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote119 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
4 votes125 views2 answers
Postgresql default value
SQL
48 votes196 views3 answers
Psql create database
SQL
0 vote106 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote120 views1 answer
How to print records of employees hired in particular month in oracle
SQL