vendas de produtos da mercearia

criar-mercearia.sql

DROP DATABASE dbMercearia_v4;
CREATE DATABASE dbMercearia_v4;
-- SHOW DATABASES;

USE dbMercearia_v4;

CREATE TABLE tbVenda (
    id INT PRIMARY KEY AUTO_INCREMENT,
    data_venda date,
    cliente varchar(30),
    produto varchar(20),
    quantidade int,
    valor decimal(5,2)
);

-- SHOW TABLES;
-- SHOW COLUMNS FROM tbVenda;

inserir-vendas.sql

USE dbMercearia_v4;

INSERT INTO tbVenda(data_venda, produto, quantidade, cliente, valor) VALUES
  ("2022-06-12", "PAÇOCA", 7, "Boris",7),
  ("2022-06-16", "MANTEIGA", 10, "Brian",70),
  ("2022-06-13", "PAO", 8, "Deirdre",4),
  ("2022-06-05", "PAO", 3, "Jacob",1.5),
  ("2022-06-16", "LEITE", 6, "Isaac",25.74),
  ("2022-06-21", "MANTEIGA", 6, "Ian",42),
  ("2022-06-23", "MANTEIGA", 1, "Boris",7),
  ("2022-06-11", "PAO", 2, "Jason",1),
  ("2022-06-23", "PAÇOCA", 3, "Boris",3),
  ("2022-06-26", "MANTEIGA", 9, "Amanda",63),
  ("2022-06-08", "PAÇOCA", 10, "Jason",10),
  ("2022-06-28", "PAÇOCA", 6, "Bella",6),
  ("2022-06-03", "LEITE", 3, "Amanda",12.87),
  ("2022-06-18", "LEITE", 8, "Audrey",34.32),
  ("2022-06-09", "QUEIJO", 5, "Deirdre",125),
  ("2022-06-02", "MANTEIGA", 6, "Alison",42),
  ("2022-06-14", "PAÇOCA", 5, "Alison",5),
  ("2022-06-04", "PRESUNTO", 6, "Amanda",42),
  ("2022-06-09", "QUEIJO", 5, "Jason",125),
  ("2022-06-13", "MANTEIGA", 9, "Audrey",63),
  ("2022-06-29", "LEITE", 4, "Irene",17.16),
  ("2022-06-10", "PAO", 3, "Irene",1.5),
  ("2022-06-03", "PRESUNTO", 1, "Deirdre",7),
  ("2022-06-25", "PAO", 2, "Faith",1),
  ("2022-06-11", "MANTEIGA", 10, "Ian",70),
  ("2022-06-15", "PAO", 8, "Ian",4),
  ("2022-06-27", "PRESUNTO", 1, "Alison",7),
  ("2022-06-21", "MANTEIGA", 9, "Audrey",63),
  ("2022-06-01", "MANTEIGA", 6, "Jennifer",42),
  ("2022-06-16", "PRESUNTO", 5, "Audrey",35),
  ("2022-06-12", "PAÇOCA", 8, "Ian",8),
  ("2022-06-18", "QUEIJO", 8, "Irene",200),
  ("2022-06-18", "MANTEIGA", 7, "Ian",49),
  ("2022-06-16", "LEITE", 3, "Amanda",12.87),
  ("2022-06-28", "MANTEIGA", 1, "Audrey",7),
  ("2022-06-25", "PAO", 1, "Isaac",0.5),
  ("2022-06-05", "PAÇOCA", 10, "Bella",10),
  ("2022-06-02", "LEITE", 1, "Audrey",4.29),
  ("2022-06-14", "LEITE", 10, "Audrey",42.9),
  ("2022-06-09", "MANTEIGA", 3, "Alison",21),
  ("2022-06-27", "PAO", 5, "Alison",2.5),
  ("2022-06-18", "PAÇOCA", 1, "Irene",1),
  ("2022-06-06", "QUEIJO", 6, "Faith",150),
  ("2022-06-09", "MANTEIGA", 5, "Jacob",35),
  ("2022-06-14", "PAÇOCA", 7, "Deirdre",7),
  ("2022-06-05", "QUEIJO", 4, "Isaac",100),
  ("2022-06-15", "PRESUNTO", 9, "Jennifer",63),
  ("2022-06-11", "PAO", 6, "Isaac",3),
  ("2022-06-07", "MANTEIGA", 3, "Bella",21),
  ("2022-06-02", "PAO", 7, "Isaac",3.5),
  ("2022-06-09", "PAÇOCA", 3, "Ian",3),
  ("2022-06-09", "LEITE", 2, "Bella",8.58),
  ("2022-06-26", "PAÇOCA", 3, "Jason",3),
  ("2022-06-21", "MANTEIGA", 7, "Jason",49),
  ("2022-06-30", "QUEIJO", 2, "Alison",50),
  ("2022-06-30", "QUEIJO", 4, "Boris",100),
  ("2022-06-12", "PRESUNTO", 6, "Jennifer",42),
  ("2022-06-24", "PRESUNTO", 9, "Jennifer",63),
  ("2022-06-17", "MANTEIGA", 9, "Irene",63),
  ("2022-06-19", "PAO", 3, "Jennifer",1.5),
  ("2022-06-06", "PRESUNTO", 7, "Deirdre",49),
  ("2022-06-27", "MANTEIGA", 10, "Ian",70),
  ("2022-06-27", "PAO", 1, "Faith",0.5),
  ("2022-06-24", "LEITE", 10, "Alison",42.9),
  ("2022-06-16", "PAÇOCA", 10, "Isaac",10),
  ("2022-06-17", "PAÇOCA", 10, "Boris",10),
  ("2022-06-14", "LEITE", 5, "Boris",21.45),
  ("2022-06-13", "MANTEIGA", 5, "Boris",35),
  ("2022-06-01", "PRESUNTO", 6, "Irene",42),
  ("2022-06-05", "MANTEIGA", 8, "Audrey",56),
  ("2022-06-02", "LEITE", 3, "Irene",12.87),
  ("2022-06-14", "LEITE", 3, "Isaac",12.87),
  ("2022-06-23", "PRESUNTO", 9, "Jacob",63),
  ("2022-06-21", "PAO", 7, "Deirdre",3.5),
  ("2022-06-12", "PAO", 9, "Evan",4.5),
  ("2022-06-12", "LEITE", 2, "Jacob",8.58),
  ("2022-06-11", "LEITE", 5, "Deirdre",21.45),
  ("2022-06-02", "PAO", 2, "Faith",1),
  ("2022-06-16", "LEITE", 6, "Isaac",25.74),
  ("2022-06-30", "MANTEIGA", 1, "Isaac",7),
  ("2022-06-25", "PAO", 4, "Isaac",2),
  ("2022-06-08", "LEITE", 2, "Amanda",8.58),
  ("2022-06-29", "PAO", 8, "Audrey",4),
  ("2022-06-01", "QUEIJO", 1, "Audrey",25),
  ("2022-06-23", "LEITE", 2, "Audrey",8.58),
  ("2022-06-01", "QUEIJO", 3, "Deirdre",75),
  ("2022-06-17", "PAÇOCA", 4, "Audrey",4),
  ("2022-06-06", "PAÇOCA", 1, "Audrey",1),
  ("2022-06-18", "MANTEIGA", 3, "Faith",21),
  ("2022-06-05", "PRESUNTO", 7, "Boris",49),
  ("2022-06-01", "MANTEIGA", 1, "Deirdre",7),
  ("2022-06-03", "LEITE", 2, "Faith",8.58),
  ("2022-06-09", "MANTEIGA", 5, "Ian",35),
  ("2022-06-03", "QUEIJO", 9, "Deirdre",225),
  ("2022-06-14", "QUEIJO", 4, "Audrey",100),
  ("2022-06-16", "PAO", 4, "Boris",2),
  ("2022-06-05", "PRESUNTO", 3, "Alison",21);


SELECT * FROM tbVenda;