Hands On 1
select d.deptname,count(*) from Employees e inner join Departments d
on d.deptid=e.deptid group by e.deptid , d.deptname
Hands On 2
select i.itemname from items i inner join orders o on i.itemid=o.itemid
and o.orderid=4499
Hands On 3
select ename from employees where deptid = (select deptid from employees where
eid=108)
Interchange 2nd and 3rd
ReplyDeleteThanks for you blog it is really helpful.
ReplyDeleteCheckout updated KYT answers here
and Full blog TCS Xplore answers updated