Skip to content

Instantly share code, notes, and snippets.

@WittmannF

WittmannF/c.sql

Created March 19, 2021 12:13
Show Gist options
  • Save WittmannF/ae4215163dd3cdc899c3deeef0504365 to your computer and use it in GitHub Desktop.
Save WittmannF/ae4215163dd3cdc899c3deeef0504365 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment