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)

 

©2018 by The real one. Proudly created with Wix.com