Respostas Lista SQL Básica 01

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Exercício 1
select *
from products
where quantityinstock > 3000
_________________________________________________________________________________________________________
Exercício 2
select *
from products
where productname like 'a%' or productname like 't%'
_________________________________________________________________________________________________________
Exercício 3
select *
from employees
where officecode = 1 and jobTitle!= ('sales rep')
_________________________________________________________________________________________________________
Exercício 4
select firstname, jobtitle
from employees
where reportsto is null
_________________________________________________________________________________________________________
Exercício 5
select *
from orders
where status='shipped' and shippedDate > '2003-10-19'
_________________________________________________________________________________________________________
Exercício 6
select *
from customers
where country not in ('USA','France') and creditlimit between 100000 and 150000
_________________________________________________________________________________________________________
Exercício 7
select *
from payments
where paymentdate between '2004-08-20' and '2004-10-08'