Use the following tables to write the SQL queries: Table Name: Employees EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 05/20/2010 AD VP 17000 90 Neena 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 105 David 02/21/2018 IT PROG 4800 60 106 Valli 10/04/2018 IT PROG 4800 60 10/06/2019 IT PROG 107 Diana 4200 60 114 Den 08/05/2015 PU MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL_CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500 1600 50090 South Brunswick US 1700 98199 Seattle US 60 IT 1400 1800 M5V 2L7 Toronto CA 90 Executive 1700 1900 YSW 9T2 Whitehorse CA 100 Finance 1700 Write SQL Command to display employee first name , salary , department name for all employees whose job id is 'IT_PROG'
Use the following tables to write the SQL queries: Table Name: Employees EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 05/20/2010 AD VP 17000 90 Neena 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 105 David 02/21/2018 IT PROG 4800 60 106 Valli 10/04/2018 IT PROG 4800 60 10/06/2019 IT PROG 107 Diana 4200 60 114 Den 08/05/2015 PU MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL_CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500 1600 50090 South Brunswick US 1700 98199 Seattle US 60 IT 1400 1800 M5V 2L7 Toronto CA 90 Executive 1700 1900 YSW 9T2 Whitehorse CA 100 Finance 1700 Write SQL Command to display employee first name , salary , department name for all employees whose job id is 'IT_PROG'
Chapter5: Multiple-table Queries
Section: Chapter Questions
Problem 21TD
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning