Python MySql Hands On

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)





Comments

Post a Comment