Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Change Christine I. Haas's Employee Number to 00 followed by last four digits of your SS number and list the new Employee Number. Update

image text in transcribed
image text in transcribed
1. Change Christine I. Haas's Employee Number to 00 followed by last four digits of your SS number and list the new Employee Number. Update emp Set empno = '00xxxx" Where lastname = HAAS'; EMPNO FIRSTNAME MIDINIT LASTNAME WORKDEPT PHONE HIREDATE JOB EDUCATION SEX BIRTHDATE SALARY Q R STINE I HAAS 3970 19 5 01 01 PACS 10 F 1903 00 14 52750.00 2. List names of all employees, their hire date and job. Select lastname, hiredate, job From sap lastname hiredate | job HAAS 1965-01-01 PRES THOMPSON 1873-10-10 MANAGER KWAN 1975 04-05 MANAGER GEYER 1949 08-17 MANAGER STERN 1973-09-14 MANAGER PULASKI 1960-09-30 MANAGER HENDERSON 1970-08-15 MANAGER SPENSER 1980-06-19 MANAGER LUCCHESI 1959-05-16 SALESREP O'CONNEL 1963-12-05 CLERK QUINTANA 1971-07-28 ANALYST NICHOLAS 1876-12-15 ANALYST ADAMSON 1972-02-12 DESIGNER PIANKA 1977-10-11 DESIGNER YOSHIMURA 1978 09-15 DESIGNER SCOUTTEN 1973-07-07 DESIGNER WALKER 1974-07-26 DESIGNER BROWN 1966-03-03 DESIGNER JONES 1979-04-11 DESIGNER LUTZ 1969-00-29 DESIGNER JEFFERSON 1968-11-21 CLERK MARINO 1979-12-05 CLERK SMITH 1969-10-30 CLERK JOHNSON 1975 09-11 CLERK PEREZ 1980-09-30 CLERK 3. How many employees are there

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cases In Communications Law

Authors: Michael T Simpson, John Zelezny

6th Edition

1111791910, 9781111791919

More Books

Students also viewed these General Management questions

Question

The relevance of the information to the interpreter

Answered: 1 week ago

Question

The background knowledge of the interpreter

Answered: 1 week ago