Database: image_and_language
Question: State the name of the object class that has in most images.
Evidence: object class that has in most images refers to OBJ_CLASS where MAX(COUNT(OBJ_CLASS_ID));
SQL: SELECT OBJ_CLASS FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID GROUP BY T2.OBJ_CLASS ORDER BY COUNT(T1.OBJ_CLASS_ID) DESC LIMIT 1

Database: movies_4
Question: List all the unspecified gender characters.
Evidence: characters refers to character_name; gender = 'Unspecified'
SQL: SELECT T1.character_name FROM movie_cast AS T1 INNER JOIN gender AS T2 ON T1.gender_id = T2.gender_id WHERE T2.gender = 'Unspecified'

Database: university
Question: Compute the average score of the university located in Brazil.
Evidence: average score refers to avg(score); located in Brazil refers to country_name = 'Brazil';
SQL: SELECT AVG(T2.score) FROM university AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.university_id INNER JOIN country AS T3 ON T3.id = T1.country_id WHERE T3.country_name = 'Brazil'

Database: donor
Question: What is the name of the vendor that the project "Bloody Times" uses for their resources?
Evidence: project "Bloody Times" refers to title = 'Bloody Times'
SQL: SELECT T3.vendor_name FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid INNER JOIN resources AS T3 ON T2.projectid = T3.projectid WHERE T1.title = 'Bloody Times'

Database: movie_3
Question: How many percent of customers were inactive?
Evidence: inactive refers to active = 0; percent = Divide (Count (customer_id where active = 0), Count(customer_id)) * 100
SQL: SELECT CAST(SUM(IIF(active = 0, 1, 0)) AS REAL) * 100 / COUNT(customer_id) FROM customer

Database: retail_world
Question: How many customers are there in the country with the highest number of customers?
Evidence: highest number refers to max(count(CustomerID))
SQL: SELECT COUNT(CustomerID) FROM Customers GROUP BY Country ORDER BY COUNT(CustomerID) DESC LIMIT 1

Database: video_games
Question: Compute the average number of sales in region ID 3.
Evidence: average = AVG(MULTIPLY(num_sales, 100000));
SQL: SELECT AVG(T.num_sales * 100000) FROM region_sales AS T WHERE T.region_id = 3

Database: student_loan
Question: What is the average time for a disabled student to be absent from school?
Evidence: average time refers to DIVIDE(SUM(`month`), COUNT(name))
SQL: SELECT AVG(T1.month) FROM longest_absense_from_school AS T1 INNER JOIN disabled AS T2 ON T1.`name` = T2.`name`

Database: cs_semester
Question: Which student failed the course Intro to Database 2? Please give his or her full name.
Evidence: If grade is NULL, it means that this student fails to pass the course; full name refers to f_name and l_name;
SQL: SELECT T1.f_name, T1.l_name FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T2.grade IS NULL AND T3.name = 'Intro to Database 2'

Database: food_inspection_2
Question: When did Renaldi's Pizza had its first inspection?
Evidence: Renaldi's Pizza refers to dba_name = 'RENALDI''S PIZZA'; first inspection refers to min(inspection_date)
SQL: SELECT MIN(T2.inspection_date) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.dba_name = 'RENALDI''S PIZZA'

Database: food_inspection
Question: How many establishments with the tax code H24 have complaint inspections of 5 or more?
Evidence: establishments with the tax code H24 refer to business_id where tax_code = 'H24'; complaint inspections of 5 or more refer to inspections where type = 'Complaint' and COUNT(business_id) ≥ 5;
SQL: SELECT COUNT(*) FROM ( SELECT T1.business_id FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.tax_code = 'H24' AND T1.type = 'Complaint' GROUP BY T1.business_id HAVING COUNT(T1.business_id) > 5 ) T3

Database: retail_world
Question: List the name, address, and phone number of companies that supply products for more than thirty dollars per unit.
Evidence: more than thirty dollars per unit refers to UnitPrice > 30
SQL: SELECT T2.CompanyName, T2.Address, T2.Phone FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.UnitPrice > 30

Database: european_football_1
Question: What was the final score for the game Bursaspor vs Denizlispor on 2009/4/26?
Evidence: Bursaspor vs Denizlispor are names of teams where HomeTeam = 'Bursaspor' and AwayTeam = 'Denizlispor'; Date = '2009-04-26'; final score refers to FTHG, FTAG;
SQL: SELECT FTHG, FTAG FROM matchs WHERE Date = '2009-04-26' AND HomeTeam = 'Bursaspor' AND AwayTeam = 'Denizlispor'

Database: world_development_indicators
Question: Which country has the lowest percentage of arable land?
Evidence: which country refers to countryname; the lowest percentage of arable land refers to min(value where indicatorname = 'Arable land (% of land area)')
SQL: SELECT CountryName FROM Indicators WHERE IndicatorName LIKE 'Arable land (% of land area)' ORDER BY Value DESC LIMIT 1

Database: food_inspection_2
Question: Among the establishments that failed the inspection in February 2010, list the names of the employees with a salary greater than 70% of the average salary of all employees.
Evidence: failed the inspection refers to results = 'Fail'; in January 2010 refers to inspection_date like '2010-01%'; name of employee refers to first_name, last_name; a salary greater than 70% of the average salary refers to salary > multiply(avg(salary), 0.7)
SQL: SELECT DISTINCT T1.employee_id FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T2.results = 'Fail' AND strftime('%Y-%m', T2.inspection_date) = '2010-02' AND T1.salary > 0.7 * ( SELECT AVG(salary) FROM employee )

Database: cs_semester
Question: Of the students with high salaries, how many took the computer vision course?
Evidence: high salaries refers to salary = 'High';
SQL: SELECT COUNT(T1.student_id) FROM RA AS T1 INNER JOIN registration AS T2 ON T2.student_id = T1.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T1.salary = 'high' AND T3.name = 'Computer Vision'

Database: cs_semester
Question: List the student's email with grade of B in a course with difficulty greater than the 80% of average difficulty of all courses.
Evidence: difficulty refers to diff; course with difficulty greater than the 80% of average difficulty refers to diff > MULTIPLY(AVG(diff), 80%);
SQL: SELECT T2.email FROM registration AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T1.course_id = T3.course_id WHERE T1.grade = 'B' GROUP BY T3.diff HAVING T3.diff > AVG(T3.diff) * 0.8

Database: image_and_language
Question: What is the relationship between object sample no.12 and no.8 of image no.2345511?
Evidence: relationship refers to PRED_CLASS; object sample no.12 and no.8 of image no.2345511 refers to IMG_ID = 2345511 AND OBJ1_SAMPLE_ID = 12 AND OBJ2_SAMPLE_ID = 8
SQL: SELECT T1.PRED_CLASS FROM PRED_CLASSES AS T1 INNER JOIN IMG_REL AS T2 ON T1.PRED_CLASS_ID = T2.PRED_CLASS_ID WHERE T2.IMG_ID = 2345511 AND T2.OBJ1_SAMPLE_ID = 12 AND T2.OBJ2_SAMPLE_ID = 8

Database: shipping
Question: Among all shipments placed by Sunguard Window Tinting & Truck Accessories in 2017, identify the percentage of shipments whose weight exceeded 10,000 pounds.
Evidence: "Sunguard Window Tinting & Truck Accessories" is the cust_name; weight exceed 10,000 pounds refers to weight > = 10000; in 2017 refers to Cast(ship_date AS DATE) = 2017; percentage = Divide (Sum(weight > = 10000), Sum(weight)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T1.weight >= 10000 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM shipment AS T1 INNER JOIN customer AS T2 ON T1.cust_id = T2.cust_id WHERE T2.cust_name = 'Sunguard Window Tinting & Truck Accessories' AND STRFTIME('%Y', T1.ship_date) = '2017'