Respostas Lista SQL Básica 02

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Exercício 1
select productline, count(*) as qte
from products
group by productLine
____________________________________________________________________________________________________________
2)
select productcode, sum(quantityordered)
from orderdetails
group by productcode
having QTE>1000
 
 
3)
select jobtitle, count(employeeNumber)
from employees
group by jobtitle
 
4)
select orderdate, count(*) as QTE
from orders
where status = 'cancelled'
group by orderdate
 
5)
select count(*) as 'QTE Pedidos Despachados'
from orders
where status = 'shipped' and shippeddate > '2004-05-09'
 
6)
select country, count(*) as 'Quantidade de Clientes por Pais'
from customers
where creditlimit > 50000 and country!= 'USA'
group by country
 
7)
select paymentdate, count(*) as QTE, sum(amount) as Soma, avg(amount) as Média
from payments
group by paymentDate