Assume the following two tables are in the ORION database. Table_1 E ID Table_2 DEPT Gender...

Transcribed Image Text:

Assume the following two tables are in the ORION database. Table_1 E ID Table_2 DEPT Gender T Date E ID S_ID ... Please find and list all syntax errors in the following query. Your result should be like the following: 1. Syntax error 1 2. Syntax error 2 : n. Syntax error n Note: your marks will be deducted if your listed error is not an error. Proc sql; Title` `title content"; Select e.e_ID, e.gender, e.DEPT, a.s_ID From Table_1 'e' inner join orion. Table_2 a Where a.e_ID=e.e_ID Order by e.DEPT, desc e.e_ID; quit; Assume the following two tables are in the ORION database. Table_1 E ID Table_2 DEPT Gender T Date E ID S_ID ... Please find and list all syntax errors in the following query. Your result should be like the following: 1. Syntax error 1 2. Syntax error 2 : n. Syntax error n Note: your marks will be deducted if your listed error is not an error. Proc sql; Title` `title content"; Select e.e_ID, e.gender, e.DEPT, a.s_ID From Table_1 'e' inner join orion. Table_2 a Where a.e_ID=e.e_ID Order by e.DEPT, desc e.e_ID; quit;