Venda Britania e Philco 21-24102016

SELECT
  x2.storeno                                         AS Loja,
  CONCAT(TRIM(x2.prdno), '-', p.name)                AS Produto,
  ROUND(SUM(x2.qtty / 1000))                         AS Qtde,
  REPLACE(ROUND(SUM((x2.price / 100) * (x2.qtty / 1000)), 2), '.', ',') AS Valor
FROM sqldados.xalog2 x2
  INNER JOIN sqlpdv.pxa
    ON (pxa.storeno = x2.storeno AND pxa.pdvno = x2.pdvno AND pxa.xano = x2.xano)
  INNER JOIN sqldados.eord e
    ON (e.storeno = pxa.storeno AND e.ordno = pxa.eordno AND e.date = pxa.date)
  INNER JOIN webpdv.produto p
    ON (p.prdno = x2.prdno)
  INNER JOIN sqldados.emp v
    ON (v.no = e.empno)
WHERE x2.date BETWEEN 20161021 AND 20161024
      AND x2.qtty > 0
      AND p.vendno IN (17, 2875, 18148, 78, 3857)
      AND p.typeno IN (9, 30)
GROUP BY x2.storeno, p.prdno
ORDER BY x2.storeno, p.name;


SELECT
  x2.storeno                                         AS Loja,
  v.name                                             AS Vendedor,
  v.cpf                                              AS CPF,
  ROUND(SUM(x2.qtty / 1000))                         AS Qtde,
  REPLACE(ROUND(SUM((x2.price / 100) * (x2.qtty / 1000)), 2), '.', ',') AS Valor
FROM sqldados.xalog2 x2
  INNER JOIN sqlpdv.pxa
    ON (pxa.storeno = x2.storeno AND pxa.pdvno = x2.pdvno AND pxa.xano = x2.xano)
  INNER JOIN sqldados.eord e
    ON (e.storeno = pxa.storeno AND e.ordno = pxa.eordno AND e.date = pxa.date)
  INNER JOIN webpdv.produto p
    ON (p.prdno = x2.prdno)
  INNER JOIN sqldados.emp v
    ON (v.no = e.empno)
WHERE x2.date BETWEEN 20161021 AND 20161024
      AND x2.qtty > 0
      AND p.vendno IN (17, 2875, 18148, 78, 3857)
      AND p.typeno IN (9, 30)
GROUP BY x2.storeno, e.empno
ORDER BY x2.storeno, v.name, p.name;

SELECT
  er.nome                                            AS Regional,
  ROUND(SUM(x2.qtty / 1000))                         AS Qtde,
  REPLACE(ROUND(SUM((x2.price / 100) * (x2.qtty / 1000)), 2), '.', ',') AS Valor
FROM sqldados.xalog2 x2
  INNER JOIN sqlpdv.pxa
    ON (pxa.storeno = x2.storeno AND pxa.pdvno = x2.pdvno AND pxa.xano = x2.xano)
  INNER JOIN webpdv.empresa_filial ef
    ON (ef.storeno = pxa.storeno)
  INNER JOIN webpdv.empresa_regiao er
    ON (er.id = ef.empresa_regiao_id)
  INNER JOIN sqldados.eord e
    ON (e.storeno = pxa.storeno AND e.ordno = pxa.eordno AND e.date = pxa.date)
  INNER JOIN webpdv.produto p
    ON (p.prdno = x2.prdno)
  INNER JOIN sqldados.emp v
    ON (v.no = e.empno)
WHERE x2.date BETWEEN 20161021 AND 20161024
      AND x2.qtty > 0
      AND p.vendno IN (17, 2875, 18148, 78, 3857)
      AND p.typeno IN (9, 30)
GROUP BY er.id
ORDER BY v.name, p.name;