(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');

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.

The essential condition of third normal form is automatically satisfied whenA) a table has only one non-key columnB) a table has only one key columnC) a table has only one primary keyD) a table has no foreign key

SQL query question

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

please help me to write the expression for these in access. please.

Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following rows ID      DEPT     SALARY   NAME    100   SALES     40000       Smith     101     RD         38000       Terry     102     HR         60000       David     103   SALES    58000       Ellie     104      RD       70000       Judy The DEPARTMENT table contains two attributes, DEPTNAME and PHONE, and has the following rows:  DEPTNAME    PHONE     RD               8596001234     SALES        8596005555    HR              8596009876  A.) The EMPLOYEE table needs to enforce the following integrity constraints: • The ID is the primary key.  • The DEPT column is a foreign key that references the DEPTNAME in the DEPARTMENT table, so that any value that appears in the DEPT column should also exist in the DEPARTMENT table.  • The value for the NAME column can never be null.  What should be the statement used to create the EMPLOYEE table, if 1) the table was created as a partitioned table such…