write SQL code to list the employee first name, last name, and salary from the employee...

Question

Question

write SQL code to list the employee first name, last name, and salary from the employee table and the department from the jobs table

engineering Computer-Science

Answer 1

Answer #1

SELECT E.FIRST_NAME, E.LAST_NAME, E.SALARY,D.DEPARTMENT FROM EMPLOYE E INNER JOIN DEPARTMENT D ON E.ID=D.ID

here we have to join the employee and department table to get the details of the department

Note : If you like my answer please rate and help me it is very Imp for me

Answer 2

Similar Homework Help Questions

write SQL code list all employee name and employee number (by this order) for all employees...

write SQL code list all employee name and employee number (by this order) for all employees with job code 709
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...

SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee table. If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should look as follows - 'Stephen (Employee ID - 777) was hired on the 1st of January, 2016 – Department: 90'. Note - The date should not have preceding...
1) Write a SQL code in order to create a table name Employee with Emp_ID (3...

1) Write a SQL code in order to create a table name Employee with Emp_ID (3 characters), Last_Name (20 characters), and First_Name (15 characters), the primary key is Emp_ID (Note: make sure this code will run on SQL view on Access database) 2) Write a SQL code to remove the table Employee that will remove both the structure and the content of the table. (

Write SQL Queries for the following Select the employee name and no of departments each employee...

Write SQL Queries for the following Select the employee name and no of departments each employee works for Select the employee names with salary greater than average salary of all employees Select the department names with no manager assigned yet. Select the employee names who work for more than 1 department. Select the employee names and their manager names (keep in mind, one employee works for multiple departments so they will have multiple managers). Select the name and salary of...
Write an SQL statement that will display the Employee ID, First name (only last 2 letters),...

Write an SQL statement that will display the Employee ID, First name (only last 2 letters), phone number (replace . by /) of all employees whose job Id has a word ‘REP’.
Given the following table structure, write the SQL code to display all the first and last...

Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that begins with the letter 'M! CREATE TABLE Persons Personi int LastName varchar(80). FirstName varchar(80). Address varchar(125). State char(2) Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that does not contain the letter 'S: CREATE TABLE Persons PersonlDint,...

Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee...

Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee id, first name, last name, job title and email of all employees working in Asia (i.e. all countries coming from the region ‘Asia’). This query must be implemented as a nested query! (ii) Using SELECT statements of SQL, find the employee id, first name, last name, job title and supervisor id of employees who had worked for more than 3 years and completed...
Database Management.... Write the SQL command that would, for each author, list the last name, first...

Database Management.... Write the SQL command that would, for each author, list the last name, first name, and title and book type of all books written by her or him that we carry,
Write Java code with JDBC (as discussed in class) to perform the following tasks: EMPLOYEE(Name, Ssn,...

Write Java code with JDBC (as discussed in class) to perform the following tasks: EMPLOYEE(Name, Ssn, Address, DeptNo, Age, Salary) DEPARTMENT(Dname, Dnumber, Budget, Mgr_ssn) Establish a logical session with a database you have created for the two relations Use JDBC to submit an SQL query and print the name of each employee with a salary greater than 100,000

Write a T-SQL query to display the emp code, emp lname, employee job code, from the...

Write a T-SQL query to display the emp code, emp lname, employee job code, from the employee table joining the job table where the employee job code equals the job table job code. Order the output by employee job code. Copy and paste the query and the output into your assignment document. (hint: use table aliases).