Use given tables as reference Write a SQL query to print details of the Workers whose SALARY lies between 100000 and 500000. Write a SQL query to print details of the Workers who have joined in Feb’2014.
Use given tables as reference Write a SQL query to print details of the Workers whose SALARY lies between 100000 and 500000. Write a SQL query to print details of the Workers who have joined in Feb’2014.
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
hello sir i am new to
Use given tables as reference
- Write a SQL query to print details of the Workers whose SALARY lies between 100000 and 500000.
- Write a SQL query to print details of the Workers who have joined in Feb’2014.
Transcribed Image Text:Table - Bonus
WORKER_REF_ID
BONUS_AMOUNT
BONUS_DATE
1
2016-02-20 00:00:00
5000
2
2016-06-11 00:00:00
3000
3
2016-02-20 00:00:00
4000
1
2016-02-20 00:00:00
4500
2016-06-11 00:00:00
3500
Table - Title
WORKER_REF_ID
WORKER_TITLE
AFFECTED_FROM
Manager
2016-02-20 00:00:00
Executive
2016-06-11 00:00:00
8
Executive
2016-06-11 00:00:00
Manager
2016-06-11 00:00:00
Asst. Manager
2016-06-11 00:00:00
7
Executive
2016-06-11 00:00:00
6
Lead
2016-06-11 00:00:00
3
Lead
2016-06-11 00:00:00
2.
4)
Transcribed Image Text:Table – Worker
WORKER_ID
FIRST_NAME
LAST_NAME
SALARY
JOINING_DATE
DEPARTMENT
001
Monika
Arora
100000
2014-02-20 09:00:00
HR
002
Niharika
Verma
80000
2014-06-11 09:00:00
Admin
003
Vishal
Singhal
300000
2014-02-20 09:00:00
HR
004
Amitabh
Singh
500000
2014-02-20 09:00:00
Admin
005
Vivek
Bhati
500000
2014-06-11 09:00:00
Admin
006
Vipul
Diwan
200000
2014-06-11 09:00:00
Account
007
Satish
Kumar
75000
2014-01-20 09:00:00
Account
008
Geetika
Chauhan
90000
2014-04-11 09:00:00
Admin
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
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