WORKSHOP 7- Internet Software Architecture PDF

WORKSHOP 7 Internet Software Architecture Table Worker: 1. Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as 2. Write an SQL query to fetch “FIRST_NAME” from the Worker table in upper case. 3. Write an SQL query to fetch unique values of...

WORKSHOP 7 Internet Software Architecture Table Worker: 1. Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as 2. Write an SQL query to fetch “FIRST_NAME” from the Worker table in upper case. 3. Write an SQL query to fetch unique values of DEPARTMENT from Worker table. 4.Write an SQL query to print the FIRST_NAME and LAST_NAME from the Worker table into a single column COMPLETE_NAME. A space char should separate them. 5.Write an SQL query to print all Worker details from the Worker table order by FIRST_NAME Ascending 6.Write an SQL query to print all Worker details from the Worker table order by FIRST_NAME Ascending and DEPARTMENT Descending. 7. Write an SQL query to print details for Workers with the first name as “Vipul” and “Satish” from Worker table 8. Write an SQL query to print details of workers excluding first names, “Vipul” and “Satish” from Worker table 9. Write an SQL query to print details of the Workers whose FIRST_NAME contains ‘a’ 10.Write an SQL query to print details of the Workers whose SALARY lies between 100000 and 500000 11. Write an SQL query to fetch the count of employees working in the department ‘Admin’ 12.Write an SQL query to show the top n (say 10) records of a table