Employees(employee_id, first_name, last name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name and job title of employees who get more than the average salary? Select one: a.SELECT last_name, job_title FROM employees WHERE salary > (SELECT avg(salary) FROM employees); b.SELECT last_name, job_title FROM employees WHERE salary >(SELECT max(salary) FROM employees); O c.SELECT lasttname, job_title FROM employees WHERE salary >(SELECT count(salary) FROM employees); O d.SELECT lastname, job_title FROM employees WHERE salary >(SELECT sum(salary) FROM employees);

Employees(employee_id, first_name, last name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name and job title of employees who get more than the average salary? Select one: a.SELECT last_name, job_title FROM employees WHERE salary > (SELECT avg(salary) FROM employees); b.SELECT last_name, job_title FROM employees WHERE salary >(SELECT max(salary) FROM employees); O c.SELECT lasttname, job_title FROM employees WHERE salary >(SELECT count(salary) FROM employees); O d.SELECT lastname, job_title FROM employees WHERE salary >(SELECT sum(salary) FROM employees);

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Below are some rows of the PROVIDERS table for a factory: PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’ b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’ c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’ d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’
Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence
How many days, years did quitting employees work in their past jobs. Name Null? Туре ΕMPLOYEE_ID FIRST_NAME LAST_NAME NUMBER (6) VARCHAR2 (20) NOT NULL VARCHAR2 (25) ΕΜΑIL NOT NULL VARCHAR2 (25) PHONE_NUMBER VARCHAR2 (20) NOT NULL DATE HIRE_DATE JOB_ID NOT NULL VARCHAR2 (10) NUMBER (8,2) NUMBER (2,2) SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID NUMBER (6) NUMBER (4) Name Null? Туре NOT NULL NUMBER (6) ΕMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMENT_ID NOT NULL DATE NOT NULL DATE NOT NULL VARCHAR2 (10) NUMBER (4)
Based on the following table, please find the customers who locate in the same state. sales.customers *customer_id first_name last_name phone email street city state zip_code . Based on the following table, please display the staff and their corresponding manager in the same store. Please display staff’s full name in one column, manager’s full name in another column, and store_id. sales.staffs *staff_id first_name last_name email phone active store_id manager_id
code of create table and insert table only please
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
Create a function that will calculate the total amount after tax (note: total amount after tax = amount + (amount * .15 ) (hint: use the following query before building the function: SET GLOBAL log_bin_trust_function_creators = 1 )
Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name of all employees who's managed by 'KING'? Select one: a.SELECT e.last_name FROM employees e, employees m WHERE upper(last_name) = 'KING' b.SELECT e.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id and upper(m.last_name) = 'KING' c.none of the above d.SELECT m.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id
SELECT FIRST_NAME, LAST_NAME, SCHOOL_FEE FROM STUDENT, FEE_PAYMENT WHERE STUDENT. STUDENT_ID=FEE_PAYMENT. STUDENT_ID ORDER BY FIRST_NAME
Employees(employee id, first name, last name, salary, hire date, job title, manager id, department id) Departments(department id, department name, location_ id) Which of the following queries will display the name of all employees who does not work for 'EXECUTIVE' department a.SELECT first name, last name FROM employees WHERE department id not in (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE'); b.SELECT first name, last name FROM employees WHERE department id != (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE'); c.SELECT first name, last name FROM employees WHERE department id = (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE'); %3D d.SELECT first name, last name FROM employees WHERE department id In (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE');
Question 5 Suppose that you have the following table: CREATE TABLE coupons ( coupon id INTEGER name VARCHAR2 (30) duration INTERVAL YEAR (3) TO MONTH Now, considers the following INSERT statement: INSERT INTO coupons (coupon id, name, duration) VALUES (4, 'BD1.5 Corn Flakes, INTERVAL 1- 3 YEAR TO MONTH) The above INSERT statement stores the following data: A. 4 BD1.5 Corn Flakes +000-14 4 BD1.5 Corn Flakes +014-00 4 BD1.5 Corn Flakes +014 None of the above
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'