SQL Interview Questions - Events data

 




Comments

Post a Comment

Popular posts from this blog

SQL Interview Questions - SqlWorldCup

  You are given two tables,   teams   and   matches , with the following structures: create table teams ( team_id integer not null, team_name varchar(30) not null, unique(team_id) ); create table matches ( match_id integer not null, host_team integer not null, guest_team integer not null, host_goals integer not null, guest_goals integer not null, unique(match_id) ); Each record in the table  teams  represents a single soccer team. Each record in the table  matches  represents a finished match between two teams. Teams ( host_team ,  guest_team ) are represented by their IDs in the  teams  table ( team_id ). No team plays a match against itself. You know the result of each match (that is, the number of goals scored by each team). You would like to compute the total number of points each team has scored after all the matches described in the table. The scoring rules are as ...
Read more

SQL Interview Questions - Second hightest Salary

Problem Statement: Find the second highest salary of an employee Table structure   create table employee (id int, name varchar(20), salary int); insert into employee (id, name,salary) values(1,'Shad',2000); insert into employee (id, name,salary) values(2, 'Arif', 1500); insert into employee (id, name,salary) values(3, 'Sarif', 1400); insert into employee (id, name,salary) values(4,'Marif', 1300); insert into employee (id, name,salary) values(5, 'Saleem',1999); insert into employee (id, name,salary) values(6, 'tarif', 1200); insert into employee (id, name,salary) values(7, 'jarif', 1100); insert into employee (id, name,salary) values(8, 'Darif',1000); Solutions: select distinct salary from employee e1  where 2=  ( select count(distinct salary) from employee e2   where e1.salary<=e2.salary  )  
Read more