{"id":"https://openalex.org/W2286501037","doi":"https://doi.org/10.1145/2839509.2844640","title":"Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students' Success","display_name":"Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students' Success","publication_year":2016,"publication_date":"2016-02-17","ids":{"openalex":"https://openalex.org/W2286501037","doi":"https://doi.org/10.1145/2839509.2844640","mag":"2286501037"},"language":"en","primary_location":{"id":"doi:10.1145/2839509.2844640","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2839509.2844640","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 47th ACM Technical Symposium on Computing Science Education","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://opus.lib.uts.edu.au/bitstream/10453/41087/1/SIGCSE2016.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5017006322","display_name":"Alireza Ahadi","orcid":"https://orcid.org/0000-0002-2018-3065"},"institutions":[{"id":"https://openalex.org/I114017466","display_name":"University of Technology Sydney","ror":"https://ror.org/03f0f6041","country_code":"AU","type":"education","lineage":["https://openalex.org/I114017466"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Alireza Ahadi","raw_affiliation_strings":["University of Technology Sydney, Sydney, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Technology Sydney, Sydney, Australia","institution_ids":["https://openalex.org/I114017466"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069299547","display_name":"Vahid Behbood","orcid":null},"institutions":[{"id":"https://openalex.org/I114017466","display_name":"University of Technology Sydney","ror":"https://ror.org/03f0f6041","country_code":"AU","type":"education","lineage":["https://openalex.org/I114017466"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Vahid Behbood","raw_affiliation_strings":["University of Technology Sydney, Sydney, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Technology Sydney, Sydney, Australia","institution_ids":["https://openalex.org/I114017466"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035948107","display_name":"Arto Vihavainen","orcid":null},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Arto Vihavainen","raw_affiliation_strings":["University of Helsinki, Helsinki, Finland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082791746","display_name":"Julia Prior","orcid":"https://orcid.org/0000-0002-7182-0984"},"institutions":[{"id":"https://openalex.org/I114017466","display_name":"University of Technology Sydney","ror":"https://ror.org/03f0f6041","country_code":"AU","type":"education","lineage":["https://openalex.org/I114017466"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Julia Prior","raw_affiliation_strings":["University of Technology Sydney, Sydney, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Technology Sydney, Sydney, Australia","institution_ids":["https://openalex.org/I114017466"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047100005","display_name":"Raymond Lister","orcid":"https://orcid.org/0000-0001-5780-0445"},"institutions":[{"id":"https://openalex.org/I114017466","display_name":"University of Technology Sydney","ror":"https://ror.org/03f0f6041","country_code":"AU","type":"education","lineage":["https://openalex.org/I114017466"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Raymond Lister","raw_affiliation_strings":["University of Technology Sydney, Sydney, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Technology Sydney, Sydney, Australia","institution_ids":["https://openalex.org/I114017466"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":9.2745,"has_fulltext":true,"cited_by_count":76,"citation_normalized_percentile":{"value":0.97832361,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"401","last_page":"406"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9955000281333923,"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"}},"topics":[{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9955000281333923,"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/T11122","display_name":"Online Learning and Analytics","score":0.9947999715805054,"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/T10028","display_name":"Topic Modeling","score":0.9847999811172485,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8588616847991943},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8114843964576721},{"id":"https://openalex.org/keywords/mistake","display_name":"Mistake","score":0.7094124555587769},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.46190863847732544},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.43450677394866943},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.35579806566238403},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3134247064590454},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.26959145069122314}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8588616847991943},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8114843964576721},{"id":"https://openalex.org/C2777179996","wikidata":"https://www.wikidata.org/wiki/Q911222","display_name":"Mistake","level":2,"score":0.7094124555587769},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.46190863847732544},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.43450677394866943},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.35579806566238403},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3134247064590454},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.26959145069122314},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2839509.2844640","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2839509.2844640","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 47th ACM Technical Symposium on Computing Science Education","raw_type":"proceedings-article"},{"id":"pmh:oai:opus.lib.uts.edu.au:10453/41087","is_oa":true,"landing_page_url":"http://hdl.handle.net/10453/41087","pdf_url":"https://opus.lib.uts.edu.au/bitstream/10453/41087/1/SIGCSE2016.pdf","source":{"id":"https://openalex.org/S4306401357","display_name":"UTS ePRESS (University of Technology Sydney)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I114017466","host_organization_name":"University of Technology Sydney","host_organization_lineage":["https://openalex.org/I114017466"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference Proceeding"}],"best_oa_location":{"id":"pmh:oai:opus.lib.uts.edu.au:10453/41087","is_oa":true,"landing_page_url":"http://hdl.handle.net/10453/41087","pdf_url":"https://opus.lib.uts.edu.au/bitstream/10453/41087/1/SIGCSE2016.pdf","source":{"id":"https://openalex.org/S4306401357","display_name":"UTS ePRESS (University of Technology Sydney)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I114017466","host_organization_name":"University of Technology Sydney","host_organization_lineage":["https://openalex.org/I114017466"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference Proceeding"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.8999999761581421,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2286501037.pdf","grobid_xml":"https://content.openalex.org/works/W2286501037.grobid-xml"},"referenced_works_count":16,"referenced_works":["https://openalex.org/W1528113134","https://openalex.org/W1964523235","https://openalex.org/W1964849062","https://openalex.org/W1987975131","https://openalex.org/W2023745308","https://openalex.org/W2026765776","https://openalex.org/W2071100465","https://openalex.org/W2084734886","https://openalex.org/W2096431252","https://openalex.org/W2099859313","https://openalex.org/W2125054539","https://openalex.org/W2132032354","https://openalex.org/W2132516581","https://openalex.org/W2133990480","https://openalex.org/W2216374816","https://openalex.org/W6678407692"],"related_works":["https://openalex.org/W151494989","https://openalex.org/W1488984669","https://openalex.org/W2031915568","https://openalex.org/W3210031882","https://openalex.org/W4388053677","https://openalex.org/W3114457612","https://openalex.org/W2108932068","https://openalex.org/W2038123353","https://openalex.org/W4223894417","https://openalex.org/W4281757942"],"abstract_inverted_index":{"The":[0],"computing":[1],"education":[2],"community":[3],"has":[4,16],"studied":[5],"extensively":[6],"the":[7,29,36,65],"errors":[8,71],"of":[9,35,44,51,69,80,88],"novice":[10],"programmers.":[11],"In":[12],"contrast,":[13],"little":[14],"attention":[15],"been":[17],"given":[18],"to":[19],"student's":[20,37],"mistake":[21],"in":[22,40,94],"writing":[23,41,95],"SQL":[24,45,52,96],"statements.":[25],"This":[26],"paper":[27],"represents":[28],"first":[30],"large":[31],"scale":[32],"quantitative":[33],"analysis":[34],"syntactic":[38,70],"mistakes":[39],"different":[42],"types":[43,68],"queries.":[46,97],"Over":[47],"160":[48],"thousand":[49],"snapshots":[50],"queries":[53],"were":[54],"collected":[55],"from":[56],"over":[57],"2000":[58],"students":[59,73],"across":[60],"eight":[61],"years.":[62],"We":[63,75],"describe":[64,77],"most":[66],"common":[67],"that":[72],"make.":[74],"also":[76],"our":[78],"development":[79],"an":[81,85],"automatic":[82],"classifier":[83],"with":[84],"overall":[86],"accuracy":[87],"0.78":[89],"for":[90],"predicting":[91],"student":[92],"performance":[93]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":8},{"year":2023,"cited_by_count":16},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":10},{"year":2020,"cited_by_count":9},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":3}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}