JUNTURAS

--1
select country as [Pas],titleofcourtesy as [Ttulo],count(titleofcourtesy) as [Cantidad]
from employees
group by country,titleofcourtesy
--2
select e.lastname+' '+e.firstname as [empleado],
c.companyname as [cliente],c.country,sum(od.unitprice*od.quantity) as [total]
from orders o 
inner join customers c on o.customerid=c.customerid
inner join employees e on e.employeeid=o.employeeid
inner join [order details] od on o.orderid=od.orderid
where c.country='Germany'
group by od.orderid,e.lastname,e.firstname,c.companyname,c.country
--3
select e.employeeid,t.territoryDescription
from employees e
inner join employeeTerritories et on e.employeeid=et.employeeid
right join territories t on t.territoryid=et.territoryid
--4
select p.productname,p.unitprice,p.unitsinstock,s.companyname,c.categoryname
from products p
inner join suppliers s on s.supplierid=p.supplierid
inner join categories c on c.categoryid=p.categoryid
where c.categoryname like '[b-m]%'
--5
select c.companyname,count(o.customerid),c.country
from customers cinner join orders o on c.customerid=o.customerid
where c.country='germany'
group by o.customerid,c.companyname,c.country
--6
select p.categoryid,p.supplierid,count(p.productid)
from suppliers s
inner join products p on p.supplierid=s.supplierid
inner join categories c on c.categoryid=p.categoryid
where p.supplierid between 1 and 3 and p.unitprice>18
group by p.supplierid,p.categoryid
--7
select e.employeeid,e.lastname+' '+e.firstname as [empleado],t.territorydescription,r.regiondescription
from employees e 
inner join employeeterritories et on e.employeeid=et.employeeid
inner join territories t on t.territoryid=et.territoryid
inner join region r on r.regionid=t.regionid
--8
select e.lastname,e.firstname,count(et.territoryid) as [cantidad]
from employees e 
inner join employeeterritories et on e.employeeid=et.employeeid
inner join territories t on t.territoryid=et.territoryid
group by et.employeeid,e.lastname,e.firstname
order by e.lastname desc