Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE bd_ltp2_1_2015;
- USE bd_ltp2_1_2015;
- CREATE TABLE tb_aluno(
- idt_aluno INT PRIMARY KEY,
- nme_aluno VARCHAR(50) NOT NULL,
- vlr_nota1 DECIMAL(3,1) NOT NULL,
- vlr_nota2 DECIMAL(3,1) NOT NULL);
- INSERT INTO tb_aluno(idt_aluno, nme_aluno, vlr_nota1, vlr_nota2)
- VALUES (1, 'Rodrigo', 9.5, 10);
- SELECT * FROM tb_aluno;
- INSERT INTO tb_aluno(idt_aluno, nme_aluno, vlr_nota1, vlr_nota2)
- VALUES(2, 'Bob', 9.7, 9.8);
- UPDATE tb_aluno SET vlr_nota1=5.9, vlr_nota2=0.0 WHERE idt_aluno=1;
- SELECT nme_aluno, vlr_nota1, vlr_nota2, (vlr_nota1+vlr_nota2)/2 AS media,
- CASE WHEN (vlr_nota1+vlr_nota2)/2<5.0 THEN 'Reprovado' ELSE 'Aprovado' END AS resultado FROM tb_aluno;
- DELETE FROM tb_aluno WHERE idt_aluno=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement