{"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","alternate_titles":[],"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","doi":"https://doi.org/10.1145/2839509.2844640","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2839509.2844640","pdf_url":null,"source":{"id":"https://openalex.org/S4363608709","display_name":"ACM Technical Symposium on Computer Science Education (SIGCSE)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"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"},"parent_works":[],"lineage":["https://openalex.org/W2286501037"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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","observed_orcids":["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,"contributor_roles":[],"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,"observed_orcids":[]},"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,"contributor_roles":[],"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,"observed_orcids":[]},"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,"contributor_roles":[],"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 Coleman Prior","orcid":"https://orcid.org/0000-0002-7182-0984","observed_orcids":["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,"contributor_roles":[],"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","observed_orcids":["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,"contributor_roles":[],"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":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.5138,"has_fulltext":true,"cited_by_count":106,"citation_normalized_percentile":{"value":0.96142188,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"401","last_page":"406"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9922000169754028,"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/T10533","display_name":"Teaching and Learning Programming","score":0.9922000169754028,"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/T11122","display_name":"Online Learning and Analytics","score":0.00559999980032444,"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/T10260","display_name":"Software Engineering Research","score":0.0012000000569969416,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/sql-queries","display_name":"SQL queries","score":0.8519999980926514},{"id":"https://openalex.org/keywords/syntax-errors","display_name":"syntactic errors","score":0.9739999771118164},{"id":"https://openalex.org/keywords/student-programming-errors","display_name":"student programming errors","score":0.7260000109672546},{"id":"https://openalex.org/keywords/novice-programmers","display_name":"novice programmers","score":0.8960000276565552}],"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","doi":"https://doi.org/10.1145/2839509.2844640","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2839509.2844640","pdf_url":null,"source":{"id":"https://openalex.org/S4363608709","display_name":"ACM Technical Symposium on Computer Science Education (SIGCSE)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"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","doi":null,"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,"listed_in":[],"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","doi":null,"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,"listed_in":[],"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.9235000014305115,"display_name":"Quality education"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2286501037.pdf","grobid_xml":"https://content.openalex.org/works/W2286501037.grobid-xml"},"referenced_works_count":17,"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/W3003642164","https://openalex.org/W4231572712"],"related_works":["https://openalex.org/W3163403742","https://openalex.org/W2916040897","https://openalex.org/W2473995384","https://openalex.org/W4287981156","https://openalex.org/W7161656519","https://openalex.org/W2885090162","https://openalex.org/W4212995739","https://openalex.org/W7082441722","https://openalex.org/W3033482208","https://openalex.org/W4390606890"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2286501037","counts_by_year":[{"year":2026,"cited_by_count":7},{"year":2025,"cited_by_count":9},{"year":2024,"cited_by_count":12},{"year":2023,"cited_by_count":16},{"year":2022,"cited_by_count":10},{"year":2021,"cited_by_count":11},{"year":2020,"cited_by_count":12},{"year":2019,"cited_by_count":9},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":9},{"year":2016,"cited_by_count":4}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
