Banco De Dados

select nome,sobrenome,limite_credito,limite_credito * 1.1 as novolimite

from clientes

select covnt(*) as total from clientes

select categoria,SUM(estoque)as total

from produtos

group by categoria

select pedido,sum(preco_unitario * quantidade) as total

from detalhes_pedido group by pedido

select *from pedidos

select *from pagamentos

select data_pagamento,aug(valor) as media

from pagamentos group by data_pagamento

order by data_pagamento

select pais from clientes

select distinct pais from clientes

select COUNT(pais)as total from clientes

select distinct COUNT(pais)as total from clientes

select COUNT(distinct pais)as total from clientes

select *from empregados

select cargo, count(*) as total

from empregados group by cargo

select nome,sobrenome,limite_credito,limite_credito * 1.1 as novolimite

from clientes

select covnt(*) as total from clientes

select categoria,SUM(estoque)as total

from produtos

group by categoria

select pedido,sum(preco_unitario * quantidade) as total

from detalhes_pedido group by pedido

select *from pedidos

select *from pagamentos

select data_pagamento,aug(valor) as media

from pagamentos group by data_pagamento

order by data_pagamento

select pais from clientes

select distinct pais from clientes

select COUNT(pais)as total from clientes

select distinct COUNT(pais)as total from clientes

select COUNT(distinct pais)as total from clientes

select *from empregados

select cargo, count(*) as total

from empregados group by cargo

select nome,sobrenome,limite_credito,limite_credito * 1.1 as novolimite

from clientes

select covnt(*) as