{"id":"https://openalex.org/W4400224630","doi":"https://doi.org/10.1145/3663649.3664368","title":"A Feasibility Study on Automated SQL Exercise Generation with ChatGPT-3.5","display_name":"A Feasibility Study on Automated SQL Exercise Generation with ChatGPT-3.5","publication_year":2024,"publication_date":"2024-06-09","ids":{"openalex":"https://openalex.org/W4400224630","doi":"https://doi.org/10.1145/3663649.3664368"},"language":"en","primary_location":{"id":"doi:10.1145/3663649.3664368","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663649.3664368","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3663649.3664368?download=true","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3663649.3664368?download=true","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5091808239","display_name":"Willem Aerts","orcid":"https://orcid.org/0009-0008-7184-3175"},"institutions":[{"id":"https://openalex.org/I83019370","display_name":"Eindhoven University of Technology","ror":"https://ror.org/02c2kyt77","country_code":"NL","type":"education","lineage":["https://openalex.org/I83019370"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Willem Aerts","raw_affiliation_strings":["Eindhoven University of Technology, The Netherlands"],"raw_orcid":"https://orcid.org/0009-0008-7184-3175","affiliations":[{"raw_affiliation_string":"Eindhoven University of Technology, The Netherlands","institution_ids":["https://openalex.org/I83019370"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019818981","display_name":"George Fletcher","orcid":null},"institutions":[{"id":"https://openalex.org/I83019370","display_name":"Eindhoven University of Technology","ror":"https://ror.org/02c2kyt77","country_code":"NL","type":"education","lineage":["https://openalex.org/I83019370"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"George Fletcher","raw_affiliation_strings":["Eindhoven University of Technology, The Netherlands"],"raw_orcid":"https://orcid.org/0000-0003-2111-6769","affiliations":[{"raw_affiliation_string":"Eindhoven University of Technology, The Netherlands","institution_ids":["https://openalex.org/I83019370"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5059138768","display_name":"Daphne Miedema","orcid":"https://orcid.org/0000-0003-3507-677X"},"institutions":[{"id":"https://openalex.org/I83019370","display_name":"Eindhoven University of Technology","ror":"https://ror.org/02c2kyt77","country_code":"NL","type":"education","lineage":["https://openalex.org/I83019370"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Daphne Miedema","raw_affiliation_strings":["Eindhoven University of Technology, The Netherlands"],"raw_orcid":"https://orcid.org/0000-0003-3507-677X","affiliations":[{"raw_affiliation_string":"Eindhoven University of Technology, The Netherlands","institution_ids":["https://openalex.org/I83019370"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.2341,"has_fulltext":true,"cited_by_count":9,"citation_normalized_percentile":{"value":0.93364456,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"13","last_page":"19"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9678000211715698,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9678000211715698,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9366999864578247,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9355999827384949,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7226873636245728},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5180413722991943},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4289368689060211},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4043898284435272}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7226873636245728},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5180413722991943},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4289368689060211},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4043898284435272}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3663649.3664368","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663649.3664368","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3663649.3664368?download=true","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3663649.3664368","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663649.3664368","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3663649.3664368?download=true","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4400224630.pdf","grobid_xml":"https://content.openalex.org/works/W4400224630.grobid-xml"},"referenced_works_count":26,"referenced_works":["https://openalex.org/W1576004360","https://openalex.org/W1975870926","https://openalex.org/W1984954093","https://openalex.org/W2011781104","https://openalex.org/W2049134908","https://openalex.org/W2055447088","https://openalex.org/W2084734886","https://openalex.org/W2097654284","https://openalex.org/W2132516581","https://openalex.org/W2152570960","https://openalex.org/W2582325117","https://openalex.org/W2750442971","https://openalex.org/W2885090162","https://openalex.org/W2910880405","https://openalex.org/W2975800273","https://openalex.org/W3033482208","https://openalex.org/W3041823931","https://openalex.org/W3112836607","https://openalex.org/W3163403742","https://openalex.org/W3193751197","https://openalex.org/W4244170719","https://openalex.org/W4249300565","https://openalex.org/W4282973869","https://openalex.org/W4283705032","https://openalex.org/W4317952630","https://openalex.org/W4382652696"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052","https://openalex.org/W2382290278","https://openalex.org/W4395014643"],"abstract_inverted_index":{"SQL":[0,69,94],"is":[1,9,43,84],"the":[2],"standard":[3],"for":[4,68,96],"database":[5,14,90],"query":[6],"languages":[7,17],"and":[8,20,41,92],"taught":[10],"in":[11,47],"most":[12],"introductory":[13],"courses.":[15],"Query":[16],"are":[18,31],"illustrated":[19],"tested":[21],"through":[22,98],"toy":[23],"examples:":[24],"small,":[25],"accessible,":[26],"instances":[27],"of":[28],"databases.":[29],"These":[30],"not":[32,65],"always":[33],"engaging,":[34],"but":[35,71],"coming":[36],"up":[37],"with":[38],"new":[39],"examples":[40],"questions":[42,95],"time-consuming.":[44],"Existing":[45],"research":[46],"Computer":[48],"Science":[49],"Education":[50],"has":[51,64],"shown":[52],"that":[53],"Large":[54],"Language":[55],"Models":[56],"(LLMs)":[57],"can":[58],"generate":[59,89],"coding":[60],"exercises.":[61],"However,":[62],"this":[63,78],"been":[66],"demonstrated":[67],"yet":[70],"could":[72],"save":[73],"teachers":[74,97],"much":[75],"time.":[76],"In":[77],"paper,":[79],"we":[80],"study":[81],"whether":[82],"it":[83],"feasible":[85],"to":[86],"have":[87],"ChatGPT-3.5":[88],"schemas":[91],"associated":[93],"a":[99],"two-part":[100],"study.":[101]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":6}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}