The HR department needs a query that prompts the user for an employee last name. The query then displays the last name and hire date of any employee in the same department as the employee whose name they supply (excluding that employee). For example, if the user enters Zlotkey, find all employees who work with Zlotkey (excluding Zlotkey). Enter Substitution Variable ENTER_NAME: Zlotkey OK Cancel ELAST NAME HIRE_DATE 1 Abel 11-MAY-96 2 Taylor 24-MAR-98

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question
1. The HR department needs a query that prompts the user for an employee last name. The query
then displays the last name and hire date of any employee in the same department as the
employee whose name they supply (excluding that employee). For example, if the user enters
Zlotkey, find all employees who work with Zlotkey (excluding Zlotkey).
Enter Substitution Variable
ENTER_NAME:
Zlotkey
OK
Cancel
E LAST_NAME HIRE_DATE
1 Abel
11-MAY-96
2 Taylor
24-MAR-98
Transcribed Image Text:1. The HR department needs a query that prompts the user for an employee last name. The query then displays the last name and hire date of any employee in the same department as the employee whose name they supply (excluding that employee). For example, if the user enters Zlotkey, find all employees who work with Zlotkey (excluding Zlotkey). Enter Substitution Variable ENTER_NAME: Zlotkey OK Cancel E LAST_NAME HIRE_DATE 1 Abel 11-MAY-96 2 Taylor 24-MAR-98
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON