/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 vote195 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
4 votes191 views3 answers
How to describe a table in sqlite3
SQL
5 votes188 views2 answers
Get number of columns sql
SQL
2 votes211 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
2 votes192 views1 answer
Q operator in oracle
SQL
1 vote193 views1 answer
Altrer name column postgres
SQL
23 votes176 views6 answers
How to create table in sql
SQL
0 vote191 views1 answer
How to get one year old query from plan cache
SQL
1 vote191 views1 answer
Pl sql create table from another table
SQL
0 vote186 views1 answer
Recursive query herarchical data sql server
SQL