Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

Related MCQs

• Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
• View the Exhibit and examine the structure of the EMPLOYEES and DEPARTMENTS tables. Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers? SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL;
• Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?
• The                operator takes the results of two queries and returns only rows that appear in both result sets.
•                                provides option for entering SQL queries as execution time, rather than at the development stage.
• Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
• Ranking of queries is done by which of the following?
• Which of the following queries are legal?
• Find all the tuples having a temperature greater than ‘Paris’.