PYTHON MYSQL HANDS-ON ANSWERS

Handson-1 Employee Count

select d.deptname,count(*) from Employees e inner join Departments d

on d.deptid=e.deptid group by e.deptid , d.deptname

Handson -2 Find ordered items

select i.itemname from items i inner join orders o on i.itemid=o.itemid

and o.orderid=4499

Handson – 3Find name of employee

select ename from employees where deptid  = (select deptid from employees where

eid=108)