Q-9. Write an SQL query to print the FIRST_NAME from Worker table after replacing ‘a’ with ‘A’.

Q-10. Write an SQL query to print the FIRST_NAME and LAST_NAME from Worker table into a single column COMPLETE_NAME. A space char should separate them.

Q-11. Write an SQL query to print all Worker details from the Worker table order by FIRST_NAME Ascending.

Q-12. Write an SQL query to print all Worker details from the Worker table order by FIRST_NAME Ascending and DEPARTMENT Descending.

Q-13. Write an SQL query to print details for Workers with the first name as “Vipul” and “Satish” from Worker table.

Q-14. Write an SQL query to print details of workers excluding first names, “Vipul” and “Satish” from Worker table.

SQL related channels:

Channel for SQL learning:
@sql_res

Chennal for SQL syntax:
@sql_syntax

Chennal for SQL interview questions:
@etl_sql_interview

Wish you all blissful and prosperous Happy New Year
🥳🥳🥳

I found this video as very helpful, for streamlining my goals and habits and how to achieve them.

Hope it helps you too.. 😊

Watch here 👇
https://youtu.be/PZ7lDrwYdZc

Click below link to Refer three Tables here for writing queries👇

https://t.me/etl_sql_interview/8

Q-15. Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”.

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

Q-17. Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘i’.

Q-18. Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.

Q-19. Write an SQL query to print details of the Workers whose SALARY lies between 100000 and 500000.

Q-20. Write an SQL query to print details of the Workers who have joined in Feb’2014.

For Answers 🤔 click here👇😁
https://t.me/etl_sql_interview/32

Top 23 SQL Interview Questions & Answers

https://youtu.be/l_dph6Qu4LA

Click below link to Refer three Tables here for writing queries👇

https://t.me/etl_sql_interview/8

Answer:

1. Select FIRST_NAME AS WORKER_NAME from Worker;

2. Select upper(FIRST_NAME) from Worker;

3. Select distinct DEPARTMENT from Worker;

4. Select substring(FIRST_NAME,1,3) from Worker;

5.Select INSTR(FIRST_NAME, BINARY'a') from Worker where FIRST_NAME = 'Amitabh';

6.Select RTRIM(FIRST_NAME) from Worker;

7.Select LTRIM(DEPARTMENT) from Worker;

8.Select distinct length(DEPARTMENT) from Worker;

9.Select REPLACE(FIRST_NAME,'a','A') from Worker;

10.Select CONCAT(FIRST_NAME, ' ', LAST_NAME) AS 'COMPLETE_NAME' from Worker;

11.Select * from Worker order by FIRST_NAME asc;

12.Select * from Worker order by FIRST_NAME asc,DEPARTMENT desc;

13.Select * from Worker where FIRST_NAME in ('Vipul','Satish');

14.Select * from Worker where FIRST_NAME not in ('Vipul','Satish');

15. Select * from Worker where DEPARTMENT like 'Admin%';

16. Select * from Worker where FIRST_NAME like '%a%';

17. Select * from Worker where FIRST_NAME like '%i';

18. Select * from Worker where FIRST_NAME like '_h';

19. Select * from Worker where SALARY between 100000 and 500000;

20.Select * from Worker where year(JOINING_DATE) = 2014 and month(JOINING_DATE) = 2;

21. SELECT COUNT(*) FROM worker WHERE DEPARTMENT = 'Admin';

22. SELECT CONCAT(FIRST_NAME, ' ', LAST_NAME) As Worker_Name, Salary
FROM worker
WHERE WORKER_ID IN
(SELECT WORKER_ID FROM worker
WHERE Salary BETWEEN 50000 AND 100000);

23. SELECT DEPARTMENT, count(WORKER_ID) No_Of_Workers
FROM worker
GROUP BY DEPARTMENT
ORDER BY No_Of_Workers DESC;

24. SELECT DISTINCT W.FIRST_NAME, T.WORKER_TITLE
FROM Worker W
INNER JOIN Title T
ON W.WORKER_ID = T.WORKER_REF_ID
AND T.WORKER_TITLE in ('Manager');

25. SELECT WORKER_TITLE, AFFECTED_FROM, COUNT(*)
FROM Title
GROUP BY WORKER_TITLE, AFFECTED_FROM
HAVING COUNT(*) > 1;

Click below link to Refer three Tables here for writing queries👇

https://t.me/etl_sql_interview/8

Q-21. Write an SQL query to fetch the count of employees working in the department ‘Admin’.

Q-22. Write an SQL query to fetch worker names with salaries >= 50000 and <= 100000.

Q-23. Write an SQL query to fetch the no. of workers for each department in the descending order.

Q-24. Write an SQL query to print details of the Workers who are also Managers.

Q-25. Write an SQL query to fetch duplicate records having matching data in some fields of a table.

For Answers 🤔 click here 👇
https://t.me/etl_sql_interview/32

Click below link to Refer three tables here for writing queries👇

https://t.me/etl_sql_interview/8

Q-26. Write an SQL query to show only odd rows from a table.

Q-27. Write an SQL query to show only even rows from a table.

Q-28. Write an SQL query to clone a new table from another table.

Q-29. Write an SQL query to fetch intersecting records of two tables.

Q-30. Write an SQL query to show records from one table that another table does not have.

Click below links

To Refer three tables for writing queries👇
https://t.me/etl_sql_interview/8

To Refer questions for writing queries👇
https://t.me/etl_sql_interview/34

Answers:

26. SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) <> 0;

27. SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) = 0;

28. SELECT * INTO WorkerClone FROM Worker;

29. (SELECT * FROM Worker)
INTERSECT
(SELECT * FROM WorkerClone);

30. SELECT * FROM Worker
MINUS
SELECT * FROM Title;

covers many interesting interview questions checkout This playlist 👇


https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS


Tip: Try to do just one per day
( If possible two/day on weekends )

Click below link to Refer three tables here for writing queries 👇

https://t.me/etl_sql_interview/8

Q-31. Write an SQL query to show the current date and time.

Q-32. Write an SQL query to show the top n (say 10) records of a table.

Q-33. Write an SQL query to determine the nth (say n=5) highest salary from a table.

Q-34. Write an SQL query to determine the 5th highest salary without using TOP or limit method.

Q-35. Write an SQL query to fetch the list of employees with the same salary.

To Refer three tables for writing queries👇
https://t.me/etl_sql_interview/8

To Refer questions for writing queries👇
https://t.me/etl_sql_interview/37

Answers :

31. SELECT SYSDATE FROM DUAL;

32. SELECT * FROM (SELECT * FROM Worker ORDER BY Salary DESC)
WHERE ROWNUM <= 10;

33. SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT n-1,1;

34. SELECT Salary
FROM Worker W1
WHERE 4 = (
SELECT COUNT( DISTINCT ( W2.Salary ) )
FROM Worker W2
WHERE W2.Salary >= W1.Salary
);

35. Select distinct W.WORKER_ID, W.FIRST_NAME, W.Salary
from Worker W, Worker W1
where W.Salary = W1.Salary
and W.WORKER_ID != W1.WORKER_ID;

Most commonly asked SQL interview questions

https://youtu.be/L-URbfgxBMQ

Click below link to Refer three tables here for writing queries 👇

https://t.me/etl_sql_interview/8

Q-36. Write an SQL query to show the second highest salary from a table.

Q-37. Write an SQL query to show one row twice in results from a table.

Q-38. Write an SQL query to fetch intersecting records of two tables.

Q-39. Write an SQL query to fetch the first 50% records from a table.

Q-40. Write an SQL query to fetch the departments that have less than five people in it.

To Refer three tables for writing queries👇
https://t.me/etl_sql_interview/8

To Refer questions for writing queries👇
https://t.me/etl_sql_interview/41

Answers :

36. Select max(Salary) from Worker
where Salary not in (Select max(Salary) from Worker);

37. select FIRST_NAME, DEPARTMENT from worker W where W.DEPARTMENT='HR'
union all
select FIRST_NAME, DEPARTMENT from Worker W1 where W1.DEPARTMENT='HR';

38. (SELECT * FROM Worker)
INTERSECT
(SELECT * FROM WorkerClone);

39.SELECT *
FROM WORKER
WHERE WORKER_ID <= (SELECT count(WORKER_ID)/2 from Worker);

40. SELECT DEPARTMENT, COUNT(WORKER_ID) as 'Number of Workers' FROM Worker GROUP BY DEPARTMENT HAVING COUNT(WORKER_ID) < 5;