Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //1
- select nome from funcionario
- where nome like'%i%' and sexo = 'f'
- //2
- select SUM(valorUnitario) as total
- from produto
- //3
- select cpf from funcionario
- where year(datanascimento) < 1980
- //6
- select * from funcionario
- where (Year(curdate))- year(datanascimento)) > 20 and
- salario > 2000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement