In this video, we will solve the SQL Hard level interview question asked in HSBC and Atlassian.
SQL Script:
CREATE TABLE Salaries (
company_id INT,
employee_id INT,
employee_name VARCHAR(50),
salary INT,
PRIMARY KEY (company_id, employee_id)
);
INSERT INTO Salaries (company_id, employee_id, employee_name, salary) VALUES
(1, 1, 'Tony', 2000),
(1, 2, 'Pronub', 21300),
(1, 3, 'Tyrrox', 10800),
(2, 1, 'Pam', 300),
(2, 7, 'Bassem', 450),
(2, 9, 'Hermione', 700),
(3, 7, 'Bocaben', 100),
(3, 2, 'Ognjen', 2200),
(3, 13, 'Nyancat', 3300),
(3, 15, 'Morninngcat', 7777);
Easy - Level questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPIRr92ZlRnw6H__IgWQdetg&si=-HgJ2ZeVg1IL35f3
If you have any interesting SQL questions, feel free to send them to me at
kulkarnisneha891@gmail.com.
#sqlserver #dataanalytics #dataanalyst
#sqlqueries#sqlqueryinterviewquestionsandanswers
#sql #sqlqueries