target-benchmark/spider-queries huggingface dataset:
Database: medicine_enzyme_interaction (tables: medicine_enzyme_interaction, enzyme)
Question: What is the id and name of the enzyme with most number of medicines that can interact as 'activator'?
SQL: SELECT T1.id ,  T1.name FROM enzyme AS T1 JOIN medicine_enzyme_interaction AS T2 ON T1.id  =  T2.enzyme_id WHERE T2.interaction_type  =  'activitor' GROUP BY T1.id ORDER BY count(*) DESC LIMIT 1
Database: medicine_enzyme_interaction (tables: medicine_enzyme_interaction, enzyme)
Question: What is the id and name of the enzyme that can interact with the most medicines as an activator?
SQL: SELECT T1.id ,  T1.name FROM enzyme AS T1 JOIN medicine_enzyme_interaction AS T2 ON T1.id  =  T2.enzyme_id WHERE T2.interaction_type  =  'activitor' GROUP BY T1.id ORDER BY count(*) DESC LIMIT 1
Database: medicine_enzyme_interaction (tables: enzyme, medicine, medicine_enzyme_interaction)
Question: What is the interaction type of the enzyme named 'ALA synthase' and the medicine named 'Aripiprazole'?
SQL: SELECT T1.interaction_type FROM medicine_enzyme_interaction AS T1 JOIN medicine AS T2 ON T1.medicine_id  =  T2.id JOIN enzyme AS T3 ON T1.enzyme_id  =  T3.id WHERE T3.name  =  'ALA synthase' AND T2.name  =  'Aripiprazole'
Database: medicine_enzyme_interaction (tables: enzyme, medicine, medicine_enzyme_interaction)
Question: What is the type of interaction for the enzyme named 'ALA synthase' and the medicine named 'Aripiprazole'?
SQL: SELECT T1.interaction_type FROM medicine_enzyme_interaction AS T1 JOIN medicine AS T2 ON T1.medicine_id  =  T2.id JOIN enzyme AS T3 ON T1.enzyme_id  =  T3.id WHERE T3.name  =  'ALA synthase' AND T2.name  =  'Aripiprazole'
Database: medicine_enzyme_interaction (tables: medicine_enzyme_interaction)
Question: What is the most common interaction type between enzymes and medicine? And how many are there?
SQL: SELECT interaction_type ,  count(*) FROM medicine_enzyme_interaction GROUP BY interaction_type ORDER BY count(*) DESC LIMIT 1
Database: medicine_enzyme_interaction (tables: medicine_enzyme_interaction)
Question: What are the most common types of interactions between enzymes and medicine, and how many types are there?
SQL: SELECT interaction_type ,  count(*) FROM medicine_enzyme_interaction GROUP BY interaction_type ORDER BY count(*) DESC LIMIT 1
Database: medicine_enzyme_interaction (tables: medicine)
Question: How many medicines have the FDA approval status 'No' ?
SQL: SELECT count(*) FROM medicine WHERE FDA_approved  =  'No'
Database: medicine_enzyme_interaction (tables: medicine)
Question: How many medicines were not approved by the FDA?
SQL: SELECT count(*) FROM medicine WHERE FDA_approved  =  'No'
Database: medicine_enzyme_interaction (tables: enzyme, medicine_enzyme_interaction)
Question: How many enzymes do not have any interactions?
SQL: SELECT count(*) FROM enzyme WHERE id NOT IN ( SELECT enzyme_id FROM medicine_enzyme_interaction );
Database: medicine_enzyme_interaction (tables: enzyme, medicine_enzyme_interaction)
Question: What is the count of enzymes without any interactions?
SQL: SELECT count(*) FROM enzyme WHERE id NOT IN ( SELECT enzyme_id FROM medicine_enzyme_interaction );
Database: medicine_enzyme_interaction (tables: medicine, medicine_enzyme_interaction)
Question: What is the id and trade name of the medicines can interact with at least 3 enzymes?
SQL: SELECT T1.id ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id GROUP BY T1.id HAVING COUNT(*)  >=  3
Database: medicine_enzyme_interaction (tables: medicine, medicine_enzyme_interaction)
Question: What are the ids and trade names of the medicine that can interact with at least 3 enzymes?
SQL: SELECT T1.id ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id GROUP BY T1.id HAVING COUNT(*)  >=  3
Database: medicine_enzyme_interaction (tables: medicine_enzyme_interaction, enzyme)
Question: What are the distinct name, location and products of the enzymes which has any 'inhibitor' interaction?
SQL: SELECT DISTINCT T1.name ,  T1.location ,  T1.product FROM enzyme AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.enzyme_id  =  T1.id WHERE T2.interaction_type  =  'inhibitor'
Database: medicine_enzyme_interaction (tables: medicine_enzyme_interaction, enzyme)
Question: What are the different names, locations, and products of the enzymes that are capable inhibitor interactions?
SQL: SELECT DISTINCT T1.name ,  T1.location ,  T1.product FROM enzyme AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.enzyme_id  =  T1.id WHERE T2.interaction_type  =  'inhibitor'
Database: medicine_enzyme_interaction (tables: medicine, medicine_enzyme_interaction)
Question: List the medicine name and trade name which can both interact as 'inhibitor' and 'activitor' with enzymes.
SQL: SELECT T1.name ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id WHERE interaction_type  =  'inhibitor' INTERSECT SELECT T1.name ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id WHERE interaction_type  =  'activitor'
Database: medicine_enzyme_interaction (tables: medicine, medicine_enzyme_interaction)
Question: What are the medicine and trade names that can interact as an inhibitor and activitor with enzymes?
SQL: SELECT T1.name ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id WHERE interaction_type  =  'inhibitor' INTERSECT SELECT T1.name ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id WHERE interaction_type  =  'activitor'
Database: medicine_enzyme_interaction (tables: enzyme, medicine, medicine_enzyme_interaction)
Question: Show the medicine names and trade names that cannot interact with the enzyme with product 'Heme'.
SQL: SELECT name ,  trade_name FROM medicine EXCEPT SELECT T1.name ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id JOIN enzyme AS T3 ON T3.id  =  T2.enzyme_id WHERE T3.product  =  'Protoporphyrinogen IX'
Database: medicine_enzyme_interaction (tables: enzyme, medicine, medicine_enzyme_interaction)
Question: What are the medicine and trade names that cannot interact with the enzyme with the product 'Heme'?
SQL: SELECT name ,  trade_name FROM medicine EXCEPT SELECT T1.name ,  T1.trade_name FROM medicine AS T1 JOIN medicine_enzyme_interaction AS T2 ON T2.medicine_id  =  T1.id JOIN enzyme AS T3 ON T3.id  =  T2.enzyme_id WHERE T3.product  =  'Protoporphyrinogen IX'
Database: medicine_enzyme_interaction (tables: medicine)
Question: How many distinct FDA approval statuses are there for the medicines?
SQL: SELECT count(DISTINCT FDA_approved) FROM medicine
Database: medicine_enzyme_interaction (tables: medicine)
Question: How many different FDA approval statuses exist for medicines?
SQL: SELECT count(DISTINCT FDA_approved) FROM medicine
Database: medicine_enzyme_interaction (tables: enzyme)
Question: Which enzyme names have the substring "ALA"?
SQL: SELECT name FROM enzyme WHERE name LIKE "%ALA%"
Database: medicine_enzyme_interaction (tables: enzyme)
Question: What are the names of enzymes that include the string 'ALA'?
SQL: SELECT name FROM enzyme WHERE name LIKE "%ALA%"
Database: medicine_enzyme_interaction (tables: medicine)
Question: find the number of medicines offered by each trade.
SQL: SELECT trade_name ,  count(*) FROM medicine GROUP BY trade_name
Database: medicine_enzyme_interaction (tables: medicine)
Question: How many medicines are offered by each trade name?
SQL: SELECT trade_name ,  count(*) FROM medicine GROUP BY trade_name
Database: university_basketball (tables: university)
Question: List all schools and their nicknames in the order of founded year.
SQL: SELECT school ,  nickname FROM university ORDER BY founded
Database: university_basketball (tables: university)
Question: What are the different schools and their nicknames, ordered by their founding years?
SQL: SELECT school ,  nickname FROM university ORDER BY founded
Database: university_basketball (tables: university)
Question: List all public schools and their locations.
SQL: SELECT school ,  LOCATION FROM university WHERE affiliation  =  'Public'
Database: university_basketball (tables: university)
Question: What are the public schools and what are their locations?
SQL: SELECT school ,  LOCATION FROM university WHERE affiliation  =  'Public'
Database: university_basketball (tables: university)
Question: When was the school with the largest enrollment founded?
SQL: SELECT founded FROM university ORDER BY enrollment DESC LIMIT 1
Database: university_basketball (tables: university)
Question: Return the founded year for the school with the largest enrollment.
SQL: SELECT founded FROM university ORDER BY enrollment DESC LIMIT 1
Database: university_basketball (tables: university)
Question: Find the founded year of the newest non public school.
SQL: SELECT founded FROM university WHERE affiliation != 'Public' ORDER BY founded DESC LIMIT 1
Database: university_basketball (tables: university)
Question: What is the founded year of the non public school that was founded most recently?
SQL: SELECT founded FROM university WHERE affiliation != 'Public' ORDER BY founded DESC LIMIT 1
Database: university_basketball (tables: basketball_match)
Question: How many schools are in the basketball match?
SQL: SELECT count(DISTINCT school_id) FROM basketball_match
Database: university_basketball (tables: basketball_match)
Question: Count the number of schools that have had basketball matches.
SQL: SELECT count(DISTINCT school_id) FROM basketball_match
Database: university_basketball (tables: basketball_match)
Question: What is the highest acc percent score in the competition?
SQL: SELECT acc_percent FROM basketball_match ORDER BY acc_percent DESC LIMIT 1
Database: university_basketball (tables: basketball_match)
Question: Return the highest acc percent across all basketball matches.
SQL: SELECT acc_percent FROM basketball_match ORDER BY acc_percent DESC LIMIT 1
Database: university_basketball (tables: university, basketball_match)
Question: What is the primary conference of the school that has the lowest acc percent score in the competition?
SQL: SELECT t1.Primary_conference FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id ORDER BY t2.acc_percent LIMIT 1
Database: university_basketball (tables: university, basketball_match)
Question: Return the primary conference of the school with the lowest acc percentage score.
SQL: SELECT t1.Primary_conference FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id ORDER BY t2.acc_percent LIMIT 1
Database: university_basketball (tables: university, basketball_match)
Question: What is the team name and acc regular season score of the school that was founded for the longest time?
SQL: SELECT t2.team_name ,  t2.ACC_Regular_Season FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id ORDER BY t1.founded LIMIT 1
Database: university_basketball (tables: university, basketball_match)
Question: Return the name of the team and the acc during the regular season for the school that was founded the earliest.
SQL: SELECT t2.team_name ,  t2.ACC_Regular_Season FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id ORDER BY t1.founded LIMIT 1
Database: university_basketball (tables: university, basketball_match)
Question: Find the location and all games score of the school that has Clemson as its team name.
SQL: SELECT t2.All_Games ,  t1.location FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id WHERE team_name  =  'Clemson'
Database: university_basketball (tables: university, basketball_match)
Question: What are the all games score and location of the school called Clemson?
SQL: SELECT t2.All_Games ,  t1.location FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id WHERE team_name  =  'Clemson'
Database: university_basketball (tables: university)
Question: What are the average enrollment size of the universities that are founded before 1850?
SQL: SELECT avg(enrollment) FROM university WHERE founded  <  1850
Database: university_basketball (tables: university)
Question: Return the average enrollment of universities founded before 1850.
SQL: SELECT avg(enrollment) FROM university WHERE founded  <  1850
Database: university_basketball (tables: university)
Question: Show the enrollment and primary_conference of the oldest college.
SQL: SELECT enrollment ,  primary_conference FROM university ORDER BY founded LIMIT 1
Database: university_basketball (tables: university)
Question: What are the enrollment and primary conference for the university which was founded the earliest?
SQL: SELECT enrollment ,  primary_conference FROM university ORDER BY founded LIMIT 1
Database: university_basketball (tables: university)
Question: What is the total and minimum enrollment of all schools?
SQL: SELECT sum(enrollment) ,  min(enrollment) FROM university
Database: university_basketball (tables: university)
Question: Return the total and minimum enrollments across all schools.
SQL: SELECT sum(enrollment) ,  min(enrollment) FROM university
Database: university_basketball (tables: university)
Question: Find the total student enrollment for different affiliation type schools.
SQL: SELECT sum(enrollment) ,  affiliation FROM university GROUP BY affiliation
Database: university_basketball (tables: university)
Question: What are the total enrollments of universities of each affiliation type?
SQL: SELECT sum(enrollment) ,  affiliation FROM university GROUP BY affiliation
Database: university_basketball (tables: university, basketball_match)
Question: How many schools do not participate in the basketball match?
SQL: SELECT count(*) FROM university WHERE school_id NOT IN (SELECT school_id FROM basketball_match)
Database: university_basketball (tables: university, basketball_match)
Question: Count the number of universities that do not participate in the baketball match.
SQL: SELECT count(*) FROM university WHERE school_id NOT IN (SELECT school_id FROM basketball_match)
Database: university_basketball (tables: university)
Question: Find the schools that were either founded after 1850 or public.
SQL: SELECT school FROM university WHERE founded  >  1850 OR affiliation  =  'Public'
Database: university_basketball (tables: university)
Question: What are the schools that were either founded before 1850 or are public?
SQL: SELECT school FROM university WHERE founded  >  1850 OR affiliation  =  'Public'
Database: university_basketball (tables: university)
Question: Find how many different affiliation types there are.
SQL: SELECT count(DISTINCT affiliation) FROM university
Database: university_basketball (tables: university)
Question: Count the number of different affiliation types.
SQL: SELECT count(DISTINCT affiliation) FROM university
Database: university_basketball (tables: university)
Question: Find how many school locations have the word 'NY'.
SQL: SELECT count(*) FROM university WHERE LOCATION LIKE "%NY%"
Database: university_basketball (tables: university)
Question: How many universities have a location that contains NY?
SQL: SELECT count(*) FROM university WHERE LOCATION LIKE "%NY%"
Database: university_basketball (tables: university, basketball_match)
Question: Find the team names of the universities whose enrollments are smaller than the average enrollment size.
SQL: SELECT t2.team_name FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id WHERE enrollment  <  (SELECT avg(enrollment) FROM university)
Database: university_basketball (tables: university, basketball_match)
Question: What are the names of teams from universities that have a below average enrollment?
SQL: SELECT t2.team_name FROM university AS t1 JOIN basketball_match AS t2 ON t1.school_id  =  t2.school_id WHERE enrollment  <  (SELECT avg(enrollment) FROM university)
Database: university_basketball (tables: university)
Question: Find the number of universities that have over a 20000 enrollment size for each affiliation type.
SQL: SELECT count(*) ,  affiliation FROM university WHERE enrollment  >  20000 GROUP BY affiliation
Database: university_basketball (tables: university)
Question: What are the different affiliations, and how many schools with each have an enrollment size of above 20000?
SQL: SELECT count(*) ,  affiliation FROM university WHERE enrollment  >  20000 GROUP BY affiliation
Database: university_basketball (tables: university)
Question: Find the total number of students enrolled in the colleges that were founded after the year of 1850 for each affiliation type.
SQL: SELECT sum(Enrollment) ,  affiliation FROM university WHERE founded  >  1850 GROUP BY affiliation
Database: university_basketball (tables: university)
Question: What are the different affiliations, and what is the total enrollment of schools founded after 1850 for each enrollment type?
SQL: SELECT sum(Enrollment) ,  affiliation FROM university WHERE founded  >  1850 GROUP BY affiliation
Database: university_basketball (tables: university)
Question: What is the maximum enrollment across all schools?
SQL: SELECT max(Enrollment) FROM university
Database: university_basketball (tables: university)
Question: Return the maximum enrollment across all schools.
SQL: SELECT max(Enrollment) FROM university
Database: university_basketball (tables: basketball_match)
Question: List all information regarding the basketball match.
SQL: SELECT * FROM basketball_match
Database: university_basketball (tables: basketball_match)
Question: What is all the information about the basketball match?
SQL: SELECT * FROM basketball_match
Database: university_basketball (tables: basketball_match)
Question: List names of all teams in the basketball competition, ordered by all home scores in descending order.
SQL: SELECT team_name FROM basketball_match ORDER BY All_Home DESC
Database: university_basketball (tables: basketball_match)
Question: What are the names of all the teams in the basketball competition, sorted by all home scores in descending order?
SQL: SELECT team_name FROM basketball_match ORDER BY All_Home DESC
Database: phone_1 (tables: chip_model)
Question: the names of models that launched between 2002 and 2004.
SQL: SELECT Model_name FROM chip_model WHERE Launch_year BETWEEN 2002 AND 2004;
Database: phone_1 (tables: chip_model)
Question: Which model has the least amount of RAM? List the model name and the amount of RAM.
SQL: SELECT Model_name ,  RAM_MiB FROM chip_model ORDER BY RAM_MiB ASC LIMIT 1;
Database: phone_1 (tables: phone)
Question: What are the chip model and screen mode of the phone with hardware model name "LG-P760"?
SQL: SELECT chip_model ,  screen_mode FROM phone WHERE Hardware_Model_name = "LG-P760";
Database: phone_1 (tables: phone)
Question: How many phone hardware models are produced by the company named "Nokia Corporation"?
SQL: SELECT count(*) FROM phone WHERE Company_name = "Nokia Corporation";
Database: phone_1 (tables: chip_model, phone)
Question: What is maximum and minimum RAM size of phone produced by company named "Nokia Corporation"?
SQL: SELECT max(T1.RAM_MiB) ,  min(T1.RAM_MiB) FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name  =  T2.chip_model WHERE T2.Company_name = "Nokia Corporation";
Database: phone_1 (tables: chip_model, phone)
Question: What is the average ROM size of phones produced by the company named "Nokia Corporation"?
SQL: SELECT avg(T1.ROM_MiB) FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name  =  T2.chip_model WHERE T2.Company_name = "Nokia Corporation";
Database: phone_1 (tables: chip_model, phone)
Question: List the hardware model name and company name for all the phones that were launched in year 2002 or have RAM size greater than 32.
SQL: SELECT T2.Hardware_Model_name ,  T2.Company_name FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name  =  T2.chip_model WHERE T1.Launch_year = 2002 OR T1.RAM_MiB  >  32;
Database: phone_1 (tables: phone)
Question: Find all phones that have word 'Full' in their accreditation types. List the Hardware Model name and Company name.
SQL: SELECT Hardware_Model_name ,  Company_name FROM phone WHERE Accreditation_type LIKE 'Full';
Database: phone_1 (tables: screen_mode, phone)
Question: Find the Char cells, Pixels and Hardware colours for the screen of the phone whose hardware model name is "LG-P760".
SQL: SELECT T1.Char_cells ,  T1.Pixels ,  T1.Hardware_colours FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE T2.Hardware_Model_name = "LG-P760";
Database: phone_1 (tables: screen_mode, phone)
Question: List the hardware model name and company name for the phone whose screen mode type is "Graphics."
SQL: SELECT T2.Hardware_Model_name ,  T2.Company_name FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE T1.Type  =  "Graphics";
Database: phone_1 (tables: phone)
Question: Find the name of the company that has the least number of phone models. List the company name and the number of phone model produced by that company.
SQL: SELECT Company_name ,  count(*) FROM phone GROUP BY Company_name ORDER BY count(*) ASC LIMIT 1;
Database: phone_1 (tables: phone)
Question: List the name of the company that produced more than one phone model.
SQL: SELECT Company_name FROM phone GROUP BY Company_name HAVING count(*)  >  1;
Database: phone_1 (tables: screen_mode)
Question: List the maximum, minimum and average number of used kb in screen mode.
SQL: SELECT max(used_kb) , min(used_kb) , avg(used_kb) FROM screen_mode;
Database: phone_1 (tables: chip_model, phone)
Question: List the name of the phone model launched in year 2002 and with the highest RAM size.
SQL: SELECT T2.Hardware_Model_name FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name  =  T2.chip_model WHERE T1.Launch_year = 2002 ORDER BY T1.RAM_MiB DESC LIMIT 1;
Database: phone_1 (tables: screen_mode, chip_model, phone)
Question: What are the wifi and screen mode type of the hardware model named "LG-P760"?
SQL: SELECT T1.WiFi , T3.Type FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name  =  T2.chip_model JOIN screen_mode AS T3 ON T2.screen_mode = T3.Graphics_mode WHERE T2.Hardware_Model_name = "LG-P760";
Database: phone_1 (tables: screen_mode, chip_model, phone)
Question: List the hardware model name for the phones that have screen mode type "Text" or RAM size greater than 32.
SQL: SELECT T2.Hardware_Model_name FROM chip_model AS T1 JOIN phone AS T2 ON T1.Model_name  =  T2.chip_model JOIN screen_mode AS T3 ON T2.screen_mode = T3.Graphics_mode WHERE T3.Type = "Text" OR T1.RAM_MiB  >  32;
Database: phone_1 (tables: screen_mode, phone)
Question: List the hardware model name for the phones that were produced by "Nokia Corporation" or whose screen mode type is "Graphics."
SQL: SELECT DISTINCT T2.Hardware_Model_name FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE T1.Type  =  "Graphics" OR t2.Company_name  =  "Nokia Corporation"
Database: phone_1 (tables: screen_mode, phone)
Question: List the hardware model name for the phons that were produced by "Nokia Corporation" but whose screen mode type is not Text.
SQL: SELECT DISTINCT T2.Hardware_Model_name FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE t2.Company_name  =  "Nokia Corporation" AND T1.Type != "Text";
Database: phone_1 (tables: screen_mode, phone)
Question: List the phone hardware model and company name for the phones whose screen usage in kb is between 10 and 15.
SQL: SELECT DISTINCT T2.Hardware_Model_name , T2.Company_name FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE T1.used_kb BETWEEN 10 AND 15;
Database: phone_1 (tables: phone)
Question: Find the number of phones for each accreditation type.
SQL: SELECT Accreditation_type ,  count(*) FROM phone GROUP BY Accreditation_type
Database: phone_1 (tables: phone)
Question: How many phones belongs to each accreditation type?
SQL: SELECT Accreditation_type ,  count(*) FROM phone GROUP BY Accreditation_type
Database: phone_1 (tables: phone)
Question: Find the accreditation level that more than 3 phones use.
SQL: SELECT Accreditation_level FROM phone GROUP BY Accreditation_level HAVING count(*)  >  3