Weblabor

CREATE DATABASE kot;
USE fullkot;

CREATE TABLE kot (
  instr VARCHAR(9),
  vevo VARCHAR(10),
  elado VARCHAR(10),
  quant MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
  price DECIMAL(8,2) UNSIGNED NOT NULL DEFAULT 0,
  datum DATETIME NOT NULL DEFAULT 0
);

select   instr, vevo, elado, sum(quant),
         sum(quant*price)/sum(quant), sum(quant*price)
from     fullkot
where    vevo<>elado and datum >= \"$kezdatum\" and
         datum <= \"$vegdatum\"
group by instr, elado
order by instr, elado;