Task: Text to Code
Input (English): Step 1: For each row in Problems table, find the corresponding rows in Problem_Log table.
Step 2: find Problem_Log's problem_id, date_problem_reported of the results of step 1 whose problem_log_id equals 10
Output (English): SELECT T1.problem_id , T2.date_problem_reported FROM Problem_Log AS T1 JOIN Problems AS T2 ON T1.problem_id = T2.problem_id WHERE T1.problem_log_id = 10