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);
Created
November 18, 2024 23:26
-
-
Save criskell/02778f87c60cc95f0116e8c88c2d32d2 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment