1\ Write SQL code for the output table as shown below: Emp ID - Emp Name Gender Agev| Salary Emp Name 100502 Faten Ahmed -Gender- Age - Salary 45 $1.000.00 Emp ID - 100501 Ahmed Ali 35 $750.00 100502 Faten Ahmed F $1,000.00 $1,250.00 52 $1,300.00 55 $1,500.00 $800.00 45 100504 Sameer Ali M. 100503 Jood Majed 50 10050S Ameer Mohammed M 100504 Sameer Ali 52 $1,300.00 100506 Karam Omer 40 100505 Ameer Moham M 55 $1,500.00 100506 Karam Omer 40 $800.00 1005070 Afnan 53 $1,300.00 EEMMMMu

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
I need the answer as soon as possible
1\ Write SQL code for the output table as shown below:
- Emp Name Gender Age Salary v
100501 Ahmed Ali
100502 Faten Ahmed
100503 Jood Majed
Emp ID
-Gender Age - Salary -
45 $1,000.00
$1,300.00
Emp ID -
Emp Name
M
$750.00
$1,000.00
35
100502 Faten Ahmed
45
100504 Sameer Ali
52
55 $1,500.00
$800.00
$1,250.00
$1,300.00
5S $1,50.00
$800.00
53 $1,300.00
50
100505 Ameer Mohammed M
100504 Sameer All
52
100506 Karam Omer
M
40
100505 Ameer Moham M
100506 Karam Omer
40
1005070 Afnan
F
Transcribed Image Text:1\ Write SQL code for the output table as shown below: - Emp Name Gender Age Salary v 100501 Ahmed Ali 100502 Faten Ahmed 100503 Jood Majed Emp ID -Gender Age - Salary - 45 $1,000.00 $1,300.00 Emp ID - Emp Name M $750.00 $1,000.00 35 100502 Faten Ahmed 45 100504 Sameer Ali 52 55 $1,500.00 $800.00 $1,250.00 $1,300.00 5S $1,50.00 $800.00 53 $1,300.00 50 100505 Ameer Mohammed M 100504 Sameer All 52 100506 Karam Omer M 40 100505 Ameer Moham M 100506 Karam Omer 40 1005070 Afnan F
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY