LISTA 1 BD2

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

LISTA 1 DE EXERCÍCIOS - BANCO DE DADOS 2 - TAVARES
1. select * from PRODUCTS
 where QuantityInStock > 3009
 order by productName
2. select * from PRODUCTS
 where productName like 'A%' 
 or productName Like 'T%'
3. select * from EMPLOYEES
 where officeCode = '1' jobTitle 
 not in('Sales Rep')
4. select firstName, jobTitle
 from EMPLOYEES
 where reportsTo is null
5. select * from ORDERS
 where status='Shipped' 
 and shippedDate > '2003-12-19'
 order by shippedDate
6. select * from CUSTOMERS 
 where country not like('USA','France') 
 and creditLimit between 10000 
 and 150000
7. select * from PAYMENTS
 where paymentDate between '2004-08-20' 
 and '2004-10-08'