# Select departmentid sumsalary from employees group by

• 918
• 100% (5) 5 out of 5 people found this document helpful

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 540 - 543 out of 918 pages.

SELECT department_id, SUM(salary) FROM employees GROUP BY department_idYou want to display the employee's last name whose salary is below 10,000 and whose lastname startswith letter D.Which SQL statement give the required output format of the salary?SELECT last_name, TO_INTEGER(salary, \$999,999.99) AS "MONTHLY SALARY" FROM employees WHEREsalary < 10000 WHERE last_name IN 'D%'In creating Joins,the NATURALJOIN and USING clauses are____________Mutually ExclusiveDisplay employee id, lastname, firstname, department name, annual salary, location id of employeeswhose location id is 1700 and working in Finance Department. Label the annual salary to ANNUALSALARY.Sort the output in from highest to lowest salary. (4 POINTS)SELECT E.employee_id, E.last_name, E.first_name, D.department_name, E.salary*12 AS "ANNUALSALARY", D.location_idFROM employees EJOIN jobs J ON E.job_id = J.job_idJOIN departments D ON E.department_id = D.department_idWHERE D.location_id = 1700 AND D.department_name = 'Finance'ORDER BY "ANNUAL SALARY" DESCQuestion textObserve the following statements and decide whether the variable result’s value is TRUE or FALSE.Given that:int x = -77;int z = 43;result = (z < x && 1 != 10) ? true : false;result = (z != 43) ? true : false;Select one:FalseQuestion textRead each statement carefully and decide whether it’s TRUE or FALSE.The last line of code, with a close brace { symbol, is properly indented.Select one:FalseQuestion textTrue or False: Brackets [] are also separators used in declaring arrays.Answer:
TrueQuestion textRefer to the block of codes below. Read each statement carefully and decide whetherit’s TRUE or FALSE.There is an error in line 9.Answer:TRUEQuestion textTrue or False: Operators, in Java programming language, use special symbols to callmethods and their objects.Answer:FalseQuestion textRead each statement carefully and decide whether it’s TRUE or FALSE.There are no errors in the program.Select one:FalseQuestion textRefer to the block of codes below. Read each statement carefully and decide whetherit’s TRUE or FALSE.Line 9 uses a traditional comment which uses double forward slash.Answer: FalseQuestion textTrue or False: Many programmers can be literate with Java programming language for itis intended to be that way.Answer:TrueQuestion textTrue or False: You’ll know there’s an error if you see a red circle with an exclamationpoint in Netbeans IDE.Answer:TrueQuestion textObserve the following statements and decide whether the variable result’s value isTRUE or FALSE.Given that:int x = -77;int z = 43;result = (z < x && 1 != 10) ? true : false;result = (x = 100) >= z;Select one:TrueThe file is accurately named – Students.java.-falseThere are three (3) separators found in line 13.-FALSE
There is an error in line 9.-Trueresult = 90 < x || -1 < z;-TrueThe last line of code, with a close brace{symbol, is properly indented.

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 918 pages?