SQL Query Results
Query 1: Arrange Workers by Salary in Decreasing Order
Worker_ID First_Name Last_Name Salary Joining_Date Department
5 Vivek Bhatia 500000 2018-06-11 Admin
3 Jenisha Patel 350000 2018-02-20 Programmer
6 Vipul Diwan 200000 2014-06-11 Account
1 Monika Arora 100000 2014-02-20 HR
8 Geetika Chauhan 90000 2017-04-10 Admin
2 Niharika Verma 80000 2016-06-11 Admin
7 Satish Kumar 75000 2020-01-20 Account
4 Amitabh Singh 50000 2014-02-20 Admin
Query 2: Retrieve the First Two Characters of Each First Name
First_Name First_Two_Chars
Monika Mo
Niharika Ni
Jenisha Je
Amitabh Am
Vivek Vi
Vipul Vi
Satish Sa
Geetika Ge
Query 3: Count Workers Who Joined Between April 10, 2017, and June 20, 2018
Number of Workers: 3
SQL Query Results
Query 4: Display the Second-to-Last Record
Worker_ID 7
First_Name Satish
Last_Name Kumar
Salary 75000
Joining_Date 2020-01-20 00:00:00
Department Account
Query 5: Exclude Workers Named 'Vipul' and 'Jenisha'
Worker_ID First_Name Last_Name Salary Joining_Date Department
1 Monika Arora 100000 2014-02-20 HR
2 Niharika Verma 80000 2016-06-11 Admin
4 Amitabh Singh 50000 2014-02-20 Admin
5 Vivek Bhatia 500000 2018-06-11 Admin
7 Satish Kumar 75000 2020-01-20 Account
8 Geetika Chauhan 90000 2017-04-10 Admin
Query 6: Group Records by Department, Arranged in Ascending Order of Salary
Worker_ID First_Name Last_Name Salary Joining_Date Department
7 Satish Kumar 75000 2020-01-20 Account
6 Vipul Diwan 200000 2014-06-11 Account
4 Amitabh Singh 50000 2014-02-20 Admin
2 Niharika Verma 80000 2016-06-11 Admin
8 Geetika Chauhan 90000 2017-04-10 Admin
SQL Query Results
5 Vivek Bhatia 500000 2018-06-11 Admin
1 Monika Arora 100000 2014-02-20 HR
3 Jenisha Patel 350000 2018-02-20 Programmer
Query 7: Display Only Odd Rows Based on Worker_ID
Worker_ID First_Name Last_Name Salary Joining_Date Department
1 Monika Arora 100000 2014-02-20 HR
3 Jenisha Patel 350000 2018-02-20 Programmer
5 Vivek Bhatia 500000 2018-06-11 Admin
7 Satish Kumar 75000 2020-01-20 Account
Query 8: Display Bottom 15% of Records by Salary
Worker_ID First_Name Last_Name Salary Joining_Date Department
4 Amitabh Singh 50000 2014-02-20 Admin
Query 9: Fetch Each Department Along with the Total Salaries Paid
Department Total_Salaries
Account 275000
Admin 720000
HR 100000
Programmer 350000
Query 10: Find Customers Who Have Not Placed Any Orders
SQL Query Results
Customer_ID Customer_Name
2 Bob
4 Diana
