CREATE TABLE review (rid INT, business_id VARCHAR, user_id VARCHAR, rating FLOAT, text TEXT, year INT, month VARCHAR)
CREATE TABLE business (bid INT, business_id VARCHAR, name VARCHAR, full_address VARCHAR, city VARCHAR, latitude VARCHAR, longitude VARCHAR, review_count BIGINT, is_open TINYINT, rating FLOAT, state VARCHAR)
CREATE TABLE tip (tip_id INT, business_id VARCHAR, text TEXT, user_id VARCHAR, likes INT, year INT, month VARCHAR)
CREATE TABLE category (id INT, business_id VARCHAR, category_name VARCHAR)
CREATE TABLE user (uid INT, user_id VARCHAR, name VARCHAR)
CREATE TABLE neighborhood (id INT, business_id VARCHAR, neighborhood_name VARCHAR)
CREATE TABLE checkin (cid INT, business_id VARCHAR, count INT, day VARCHAR)

Find the number of tips written in each month
SELECT COUNT(DISTINCT (text)), month FROM tip GROUP BY month
SELECT COUNT(DISTINCT "text"), "month" FROM "tip" GROUP BY "month"