You build the following subquery to find a list of add-on cases:Select OR_CASE_ID FROM OR_CASE_VIRTUAL WHERE ADD_ON_CASE_SCH_YN = 'Y'You then include your subquery in the WHERE clause of another query to filter the results of that query to only add-on cases. SELECT defproc. PROC_NAME "Prodecure"FROM OR_CASE_ALL_PROC cprocINNER JOIN OR_PROC defprocON cproc. OR_PROC_ID = defproc. OR_PROC_IDWHERE cproc. OR_CASE_ID = (/* subquery */)This causes an error. Why doesn't this logical expression work?A) Subqueries cannot be used in the WHERE clauseB) You must join to this subquery in the FROM clause in order to use it in the WHERE clause. C) In the WHERE clause, OR_CASE_ID is a list of values, and the subquery is a single value. D) In the WHERE clause, OR_CASE_ID is a single value, and the subquery is a list of values.