"Write an SQL Queryfor fetching the details of workers with Salaries >= 5000 and <= 1000. WORKER ID FIRST_NAME LAST_NAME SALARY JOINING DATE DEPARTMENT 001 NIHARIKA ARORA 20000 2013-02-25 09:00:00 HR 002 AYUSHI GURONDIA 5000 2015-02-10 09:00c00 ADMIN 003 PRIYANSHA CHOUKSEY 25o00 2014-05-16 o9:00:00 HR 004 APARNA DESHPANDE S000 2016-12-20 09:00:o0 ADMIN 005 SHAFALI JAIN 21000 2015-08-29 09:00:00 ADMIN o06 SUCHITA JOSHI 20000 2017-02-12 og:00:00 ACCOUNT 007 SHUBHI MISHRA 15000 2018-03-23 09:00:00 ADMIN 008 DEVYANI PATIDAR 18000 2014-05-02 o9:00:00 ACCOUNT
"Write an SQL Queryfor fetching the details of workers with Salaries >= 5000 and <= 1000. WORKER ID FIRST_NAME LAST_NAME SALARY JOINING DATE DEPARTMENT 001 NIHARIKA ARORA 20000 2013-02-25 09:00:00 HR 002 AYUSHI GURONDIA 5000 2015-02-10 09:00c00 ADMIN 003 PRIYANSHA CHOUKSEY 25o00 2014-05-16 o9:00:00 HR 004 APARNA DESHPANDE S000 2016-12-20 09:00:o0 ADMIN 005 SHAFALI JAIN 21000 2015-08-29 09:00:00 ADMIN o06 SUCHITA JOSHI 20000 2017-02-12 og:00:00 ACCOUNT 007 SHUBHI MISHRA 15000 2018-03-23 09:00:00 ADMIN 008 DEVYANI PATIDAR 18000 2014-05-02 o9:00:00 ACCOUNT
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
I need the answer quickly

Transcribed Image Text:"Write an SQL Queryfor fetching the details of workers with Salaries >= 5000 and <= 1000.
WORKER ID FIRST_NAME LAST_NAME SALARY
JOINING DATE
DEPARTMENT
001
NIHARIKA
ARORA
20000 2013-02-25 09:00:00
HR
002
AYUSHI
GURONDIA
5o00 2015-02-10 o9:00c00
ADMIN
003
PRIYANSHA
CHOUKSEY 25o00
2014-05-16 09:00:00
HR
004
APARNA
DESHPANDE S000
2016-12-20 o9:00c00
ADMIN
SHAFALI
JAIN
21000 2015-08-29 09:00:00
ADMIN
006
SUCHITA
JOSHI
20000 2017-02-12 og:00:00
ACCOUNT
007
SHUBHI
MISHRA
15000 2018-03-23 09:00:00
ADMIN
008
DEVYANI
РATIDAR
18000 2014-05-02 09:00:00
ACCOUNT
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images

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

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education