(Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST_NAME , EMAIL ,PHONE_NUMBER COMMISSION_PCT, MANAGER_ID, DEPARTMENT ID) (Consider table jobs with the following colunms (JOB_ID,JOB_TITLE,MIN SALARY,MAX_SALARY) HIRE DATE , JOB_ID SALARY which query is the most appropriate to display employee id, first name and salary in hundreds for all employees whose job title is "Accountant"? * select employee_id, first_name, round(salary,-2) from employees where job_id in (select job_id from jobs where lower(job title) = 'Accountant'); select employee_id, first_name, round(salary,-2) from employees where job_id in (select job_id from jobs where lower(job_title) = 'accountant');: select employee_id, first_name, round(salary,-2) from employees where job_id = (select job_id from jobs where lower(job_title) = 'Accountant'); sélect employee_id, first_name, round(salary,-2) from employees where job_id = (select job_id from jobs where lower(job title) = 'accountant');

(Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST_NAME , EMAIL ,PHONE_NUMBER COMMISSION_PCT, MANAGER_ID, DEPARTMENT ID) (Consider table jobs with the following colunms (JOB_ID,JOB_TITLE,MIN SALARY,MAX_SALARY) HIRE DATE , JOB_ID SALARY which query is the most appropriate to display employee id, first name and salary in hundreds for all employees whose job title is "Accountant"? * select employee_id, first_name, round(salary,-2) from employees where job_id in (select job_id from jobs where lower(job title) = 'Accountant'); select employee_id, first_name, round(salary,-2) from employees where job_id in (select job_id from jobs where lower(job_title) = 'accountant');: select employee_id, first_name, round(salary,-2) from employees where job_id = (select job_id from jobs where lower(job_title) = 'Accountant'); sélect employee_id, first_name, round(salary,-2) from employees where job_id = (select job_id from jobs where lower(job title) = 'accountant');

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

Employee(empno, ename, street, city, mgrssn) work_project(eno, pno, number_of_hours) Write a query and optimize it to find employee name and project number in which they work and who live in "New_york". Identify the type of indexing to be applied on 'empno' in Employee 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 )
Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that lists the titles of films with the fewest rows in the inventory table. This query requires a subquery that computes the minimum of counts by film_id: SELECT MIN(count_film_id) FROM ( SELECT COUNT(film_id) AS count_film_id FROM inventory GROUP BY film_id ) AS temp_table; This subquery is provided in the template.
Consider Following Tables. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName, credit_hours) Enrollment (regNo, cCode, semester, Grade) Write SQL queries for the following statements. NOTE: you must use “CARTESIAN PRODUCT” query only. Display grade of ‘Ali’ in course ‘CS101’. Display all Grades of ‘Irshad’ in 7th Display names of all courses and grades of ‘Amir’. Display list of courses which are taught in 7th (course name must not repeat) Display list of all students by name and course name they have Display total number of ‘F’ grade by ‘Amir’. Display all those students who have not enrolled any course
4( This clause in SQL join is used to specify arbitrary conditions or specify columns to join using a join condition. a. OUTER JOIN b. USING clause c. ON clause d. NATURAL JOIN
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
Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. note : Note: Sql code need not java don't waste my time by giving java code
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years. 3. Find the names of buildings where more than 50 employees work. 4. The tables have…
1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.
Consider Following Tables. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName, credit_hours) Enrollment (regNo, cCode, semester, Grade) Write SQL queries for the following statements. NOTE: you must use “CARTESIAN PRODUCT” query only. Display names of all those students who have “A” Display student name and ccode of all those students who have ‘F’ grade in 5th Display data of all those students who have enrolled at least 10 Display grade of ‘Ali’ in course ‘CS101’. Display all Grades of ‘Irshad’ in 7th Display names of all courses and grades of ‘Amir’. Display list of courses which are taught in 7th (course name must not repeat) Display list of all students by name and course name they have Display total number of ‘F’ grade by ‘Amir’. Display all those students who have not enrolled any course