CREATE TABLE category (id INT, business_id VARCHAR, category_name 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 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)
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 checkin (cid INT, business_id VARCHAR, count INT, day VARCHAR)

Find the total checkins in ' Brighton Heights ' neighborhood
SELECT SUM(checkin.count) FROM business, checkin, neighborhood WHERE checkin.business_id = business.business_id AND neighborhood.business_id = business.business_id AND neighborhood.neighborhood_name = 'Brighton Heights'
SELECT SUM("checkin"."count") FROM "business" JOIN "checkin" ON "business"."business_id" = "checkin"."business_id" JOIN "neighborhood" ON "business"."business_id" = "neighborhood"."business_id" AND "neighborhood"."neighborhood_name" = 'Brighton Heights'