Show the SQL Statement for the following From the above tabl

Show the SQL Statement for the following: From the above table, list the employee ID, first name, last name, and new credit limit (which is credit_limit + 10.00) for all employees whose new credit limit is above 20.00. Sort the rows by the new credit limit.

Query1 L EMPLOYEES EMPLOYEE ID FIRST NAME LAST NAME DEPT CODE HIRE DATE CREDIT LIMIT PHONE NUMBER MANAGER Click to Add 6/1/1998 $30.00 3484 01 Susan Brown Exe Kern Sal 8/16/1999 $25.00 8722 202 Jim 201 shp $25.00 7591 2/2/2009 203 Martha Woods 201 7/1/2008 $15.00 6830 204 Ellen Owens Sa 202 sal 205 Henry 3/1/2006 $25.00 5286 Perkins 202 206 Carol Rose Act Smith shp 12/1/2008 $25.00 2259 203 207 Dan Campbell shp 4/1/2008 $25.00 1752 208 Fred 203 Mkt $15.00 3357 3/17/1999 209 Paula Jacobs 201 Sal Hoffman $25.00 2974 2/16/2007 210 Nancy 203

Solution

SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, CREDIT_LIMIT AS \'NEW CREDIT LIMIT\'

FROM L_EMPLOYEES WHERE CREDIT_LIMIT = CREDIT_LIMIT + 10.00

ORDER BY CREDIT_LIMIT