Complex SQL 3 | Scenario based Interviews Question for Product companies

In this video we will talk about a scenario based question. It is a medium complex query and these kind of questions you can expect in product based company interviews. here is the script if you want to try yourself. create table entries ( name varchar(20), address varchar(20), email varchar(20), floor int, resources varchar(10)); insert into entries values ('A','Bangalore','[email protected]',1,'CPU'),('A','Bangalore','[email protected]',1,'CPU'),('A','Bangalore','[email protected]',2,'DESKTOP') ,('B','Bangalore','[email protected]',2,'DESKTOP'),('B','Bangalore','[email protected]',2,'DESKTOP'),('B','Bangalore','[email protected]',1,'MONITOR')