"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
icon
Related questions
Question

I need the answer quickly

"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
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
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Intermediate SQL concepts
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education