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...


help me with the question below





 Use given table as reference




  1. Write an SQL query to print details of the Workers whose FIRST_NAME contains ‘a’

  2. Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘a’.


Table – Worker<br>WORKER_ID<br>FIRST_NAME<br>LAST_NAME<br>SALARY<br>JOINING_DATE<br>DEPARTMENT<br>001<br>Monika<br>Arora<br>100000<br>2014-02-20 09:00:00<br>HR<br>002<br>Niharika<br>Verma<br>80000<br>2014-06-11 09:00:00<br>Admin<br>003<br>Vishal<br>Singhal<br>300000<br>2014-02-20 09:00:00<br>HR<br>004<br>Amitabh<br>Singh<br>500000<br>2014-02-20 09:00:00<br>Admin<br>005<br>Vivek<br>Bhati<br>500000<br>2014-06-11 09:00:00<br>Admin<br>006<br>Vipul<br>Diwan<br>200000<br>2014-06-11 09:00:00<br>Account<br>007<br>Satish<br>Kumar<br>75000<br>2014-01-20 09:00:00<br>Account<br>008<br>Geetika<br>Chauhan<br>90000<br>2014-04-11 09:00:00<br>Admin<br>

Extracted 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

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here