/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

13 votes255 views6 answers
Current date sql
SQL
3 votes265 views2 answers
Mysql create database
SQL
1 vote252 views1 answer
Postgres convert exisiting column to text
SQL
0 vote269 views1 answer
Least spark sql
SQL
6 votes255 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
23 votes270 views2 answers
Query to delete a database in mysql
SQL
0 vote243 views1 answer
Oracle create package body
SQL
0 vote265 views1 answer
Test sql query
SQL
15 votes267 views4 answers
Mysql export database command line
SQL
2 votes256 views2 answers
Mysql alter column default
SQL