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 zeros
Homework Answers
Select last_name+' (Employee ID - '+' '+employeeid+' was hired on the '+CAST(DAY(hire_date) AS VARCHAR(2)) + ' ' + DATENAME(MM, hire_date) + ' ' + CAST(YEAR(hire_date) AS VARCHAR(4))+' – Department: '+Department_Id from employees where department_id is not null;
Requirement is purely based on concatenating. Please change column names if applicable. Please comment if any error
Add Answer to:
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 a SQL statement using the employees table and retrieve employees whose monthly salary...
SQL query: Write a SQL statement using the employees table and retrieve employees whose monthly salary (including their commission) is greater or equal to 5,000 but less than or equal to 17,000 (we are assuming the salary on the table is monthly). In other words, if their monthly salary was 1000 and their commission was .2, their total monthly salary would be 1200 and given the criteria above this instance would not be selected. Please display the full name of...
The Employee table consists of the following data fields: Employee ID, Employee Name, Employee Department, Employee...
The Employee table consists of the following data fields: Employee ID, Employee Name, Employee Department, Employee Manager (EMP_ID of the Employee to whom the employee reports) and Employee DOH (Date of Hire). Using the following data table, answer the questions with appropriate SQL queries. EMP_ID EMP_NAME EMP_DEPT EMP_MANAGER EMP_DOH 1 John IT 9 05-08-2010 2 Alex Finance 0 06-03-2008 3 Linda IT 9 07-02-2010 4 Robin Purchase 8 08-12-2010 5 Maki Purchase 8 09-08-2012 6 Ross Sales 7 10-05-2012 7...
A company maintains data on their employees in a table called employee. Write a query to find the highest paid employee in each department. The output should contain department_name, employee_name, and salary. Exclude employees with no department from you
A company maintains data on their employees in a table called employee. Write a query to find the highest paid employee in each department. The output should contain department_name, employee_name, and salary. Exclude employees with no department from your result. Input Format: employee table: Column Type employee_no Integer employee_name String department_no Integer salary Integer manager_no Integer department table: Column Type department_no String department_name String
Q2. Retrieve the names of all employees from the employee table to produce output on CSV...
Q2. Retrieve the names of all employees from the employee table to produce output on CSV format or delimited format with a common delimeter, rather than separete columns. Hint:Put the whole row into a string with a semicolon as the seperator(delimeter) between thecolumns: FORMAT:(fname;minit;lname) Example: EMPLOYEES -------------- James;E;Borg Frank;T;Wong Q3. Write a query to show the employees name from the employee table in this format: first letter of the first name, followed by a dot, a blank, and the full...
SQL - create statement for query For each patient, display his or her last name, first...
SQL - create statement for query For each patient, display his or her last name, first name, and the name of his or her doctor. For each pediatrics patient, display his or her ID and his or her doctor's ID and name. For each doctor, display the name and the name of the doctor's supervisor in alphabetic order of supervisor's name. Include column aliases for clarity. Note: Check for accuracy. For each doctor in one of the two areas entered...
A company maintains data on their employees in a table called employee. Write a query to find the highest paid employee in each department. The output should contain department_name, employee_name, and salary. Exclude employees with no department from your result. Input Format: employee table: Column Type employee_no Integer employee_name String department_no Integer salary Integer manager_no Integer department table: Column Type department_no String department_name String
Most questions answered within 3 hours.
-
A statistics student finds herself struggling with a newspaper
article stating that only eighteen percent of...
asked 17 minutes ago -
People with beriberi, a disease caused by a thiamin deficiency,
have elevated levels of blood pyruvate...
asked 4 minutes ago -
PYTHON Programming Exercise 2: Create a Simple Cost Calculator
Write a program that displays input fields...
asked 10 minutes ago -
1.Seki agreed that Groupon could sell 18 hot air
balloon rides on his Magical Adventures company...
asked 11 minutes ago -
A cohort study is conducted to determine whether smoking is
associated with an increased risk of...
asked 16 minutes ago -
Create the pseudo-code/flowchart for an application class named
Monogram. Its main() method inputs three variables that...
asked 17 minutes ago -
How many liters of water are required to dissolve 1.00 g of
silver chromate? Express your...
asked 20 minutes ago -
Hot: T_inlet = 80, T_out = 65
Cold: T_inlet = 10, T_out = 25
Explain in...
asked 20 minutes ago -
Two protons fly in different directions and collide. They both
have a total energy of 1.5...
asked 29 minutes ago -
What is the oxidation number of each atom in sodium phosphate,
Na3PO4?
>>> SHOW YOUR WORK...
asked 35 minutes ago -
D company purchased goods with a list price of $60000, subject
to trade discounts of 20%...
asked 38 minutes ago -
Transposable elements make up more than 40% of the human genome
and are inserted more-or-less randomly...
asked 49 minutes ago