c.sql

--1
SELECT * 
FROM "olist_order_payments_dataset" 
WHERE payment_type='voucher' 
  OR payment_type='boleto' 

--2
SELECT *, product_length_cm*product_height_cm*product_width_cm volume
FROM "olist_products_dataset"
LIMIT 5

--3
SELECT *
FROM "olist_order_reviews_dataset"
--WHERE review_comment_message=NULL
WHERE review_comment_message IS NULL
LIMIT 5

--4
SELECT strftime('%Y', order_purchase_timestamp) year, *
FROM "olist_orders_dataset"
--WHERE strftime('%Y', order_purchase_timestamp)=2017
WHERE year='2017'
LIMIT 5

--5
SELECT *
FROM "olist_customers_dataset"
WHERE customer_state='SP'
  AND customer_city<>'sao paulo'
LIMIT 5

-- views e diferença nas sintaxes do início
-- Rodrigo está como aluno