SQL Select with Multiple Conditions

Write a SQL SELECT query against the given table with three to four conditions applied at once - read the prompt carefully, several conditions are easy to miss. Asked in the Individual technical case (SQL track) stage. Candidate chose SQL over Excel for the individual technical case and described this as a basic SELECT with three to four conditions.

Using the supplied table, return documents meeting all four conditions: approved status, SOP document type, an effective date from January 1 through June 30, 2025, and a non-Finance owner department.

Output

1. Return document_id, document_title, owner_department, and effective_date.
2. Include one row per qualifying document and sort by effective_date ascending, then document_id ascending.