CREATE TABLE checkin (cid INT, business_id VARCHAR, count INT, day 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 neighborhood (id INT, business_id VARCHAR, neighborhood_name 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 review (rid INT, business_id VARCHAR, user_id VARCHAR, rating FLOAT, text TEXT, year INT, month VARCHAR)
CREATE TABLE user (uid INT, user_id VARCHAR, name VARCHAR)

Return me the number of tips that are written by Michelle in 2010 .
SELECT COUNT(DISTINCT (tip.text)) FROM tip, user WHERE tip.year = 2010 AND user.name = 'Michelle' AND user.user_id = tip.user_id
SELECT COUNT(DISTINCT "tip"."text") FROM "tip" JOIN "user" ON "tip"."user_id" = "user"."user_id" AND "user"."name" = 'Michelle' WHERE "tip"."year" = 2010