Table: kickstarter_projects
Columns: rank
total_usd
project_name
creator
category
funded
backers
closing_date

Question: What was the minimum % funded of the project that was closed on 2012-05-18?
SQL: SELECT MIN("funded") FROM kickstarter_projects WHERE "closing_date" = '2012-05-18'

Question: What was the maximum total USD collected by Pebble Technology?
SQL: SELECT MAX("total_usd") FROM kickstarter_projects WHERE "creator" = 'Pebble Technology'

Question: What was the category of the project name Mighty No. 9?
SQL: SELECT "category" FROM kickstarter_projects WHERE "project_name" = 'Mighty No. 9'

Question: Project Name Pebble: E-Paper Watch for Iphone and Android was ranked how many times?
SQL: SELECT COUNT("rank") FROM kickstarter_projects WHERE "project_name" = 'Pebble: E-Paper Watch for iPhone and Android'