Skip to content

Instantly share code, notes, and snippets.

@criskell
Created November 18, 2024 23:26
Show Gist options
  • Select an option

  • Save criskell/02778f87c60cc95f0116e8c88c2d32d2 to your computer and use it in GitHub Desktop.

Select an option

Save criskell/02778f87c60cc95f0116e8c88c2d32d2 to your computer and use it in GitHub Desktop.
CREATE TABLE demo (ID integer primary key, Name varchar(20), Hint text );
CREATE TABLE vendas (
    ID_Venda INTEGER primary key AUTOINCREMENT,
      Curso VARCHAR(100),
      Aluno VARCHAR(100),
      Estado VARCHAR(100),
      Valor DECIMAL(10.2)
);

INSERT INTO vendas (ID_Venda, Curso, Aluno, Estado, Valor)
VALUES
(1, 'Excel', 'João', 'SP', 100),
(2, 'VBA', 'Lucas', 'RJ', 50),
(3, 'Excel', 'Alice', 'SP', 100),
(4, 'Excel', 'Pedro', 'PE', 100),
(5, 'VBA', 'Amanda', 'SP', 50),
(6, 'Power BI', 'Rita', 'RS', 80),
(7, 'Excel', 'Julia', 'RJ', 100),
(8, 'Power BI', 'Caio', 'SP', 80),
(9, 'Power BI', 'Lara', 'MG', 80),
(10, 'Excel', 'Rogério', 'AC', 80),
(11, 'SQL', 'MeuNome', 'SP', 500);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment