(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

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
do part ( v- vii)
Create table statements (file name must be: 1_create_table.txt). Make sure you specify primary keys and foreign keys. Specifying “not null” constraint is optional. Specifying “on delete action” and “on update action” are optional.
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
Consider the following table: Instructor (Instructor_Id, Instructor_Name, specialization, Address, #Department_Id) Write in PL/SQL a function named NumberInstructor_department that takes the id of a department as an input parameter and returns the number of instructors who are working in that department.
Write the appropriate SQL query for each of the following questions: 1) Display details of ALL the clubs running by the college 2) Display the details of the IT club (IT is the name of the club)
31) Using functions display: a) sum of all salaries b) average of all salaries c) highest salary d) lowest salary 27) Show employees that do not work for IBM, Oracle, AWS? 28) Select all employees where commission_pct has null values? 29) Use NVL command where in commission_pct attribute will convert from null values to 0 30)Use the oracle database employees table and CASE expression to decode the department id. Display the department id, last name, salary and a column called all sql
please help me to write the expression for these in access. please.
on this table CREATE TABLE students ( std_id int NOT NULL PRIMARY KEY, f_name VARCHAR2(20), l_name VARCHAR2(20), std_address VARCHAR2(50), tel_no VARCHAR2(15), SEX VARCHAR2(10), birthdate date ); use PL/SQL oracle to solve create A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. arg is int all data are int and varchar2 and date
Subject: DatabaseWrite the SQL statements for following modification tasks: a) Add constraint to the table BORROWER named borrower_cardno_pk to create the attribute name as the primary key. b) Delete the column city from the table BORROWER c) Modify the column of "phone" in table BORROWER, change the data type into type of VARCHAR2 with length of 20.