Question

Table: Worker WORKER_I D FIRST_NAM E LAST_NAM E SALAR Y JOINING_DATE DEPARTM ENT 001 MARIA Ali 100000 2014-02-20 09:00:00 HR 002 Nimra Waqas 80000 2014-06-11 09:00:00 Admin 003 Awais Salim 300000 2014-02-20 09:00:00 HR 004 Amina Sabeen 500000 2014-02-20 09:00:00 Admin 005 KASHIF Bhati 500000 2014-06-11 09:00:00 Admin Write an SQL query to fetch “FIRST_NAME” from Worker table in upper case. Write an SQL query to delete record from Worker table Write an SQL query to fetch details of Workers with DEPARTMENT name as “Admin”. Write an SQL query to fetch details for Workers with the first name as “Maria” and “Awais” from Worker table Write an SQL query to fetch details of the Workers whose FIRST_NAME ends with ‘a’

Answer 1

Answer:

please write you question simple and easy

Explanation: