{"id":"https://openalex.org/W2473995384","doi":"https://doi.org/10.1145/2899415.2899464","title":"Students' Semantic Mistakes in Writing Seven Different Types of SQL Queries","display_name":"Students' Semantic Mistakes in Writing Seven Different Types of SQL Queries","publication_year":2016,"publication_date":"2016-07-08","ids":{"openalex":"https://openalex.org/W2473995384","doi":"https://doi.org/10.1145/2899415.2899464","mag":"2473995384"},"language":"en","primary_location":{"id":"doi:10.1145/2899415.2899464","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2899415.2899464","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 ACM Conference on Innovation and Technology in Computer Science Education","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"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/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":"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":"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":1,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":9.4772,"has_fulltext":false,"cited_by_count":61,"citation_normalized_percentile":{"value":0.97443429,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"272","last_page":"277"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.987500011920929,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.987500011920929,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9765999913215637,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10286","display_name":"Information Retrieval and Search Behavior","score":0.975600004196167,"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/computer-science","display_name":"Computer science","score":0.8654349446296692},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7348736524581909},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5011303424835205},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.48501941561698914},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2601054310798645},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.1002248227596283},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07834577560424805}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8654349446296692},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7348736524581909},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5011303424835205},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.48501941561698914},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2601054310798645},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.1002248227596283},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07834577560424805}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2899415.2899464","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2899415.2899464","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 ACM Conference on Innovation and Technology in Computer Science Education","raw_type":"proceedings-article"},{"id":"pmh:oai:opus.lib.uts.edu.au:10453/43703","is_oa":false,"landing_page_url":"http://hdl.handle.net/10453/43703","pdf_url":null,"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":null,"sustainable_development_goals":[{"score":0.8799999952316284,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W1829721446","https://openalex.org/W1964523235","https://openalex.org/W1964849062","https://openalex.org/W1984314602","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/W2216374816","https://openalex.org/W2286501037","https://openalex.org/W3003642164","https://openalex.org/W3164405036","https://openalex.org/W4285719527","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":{"Computer":[0],"science":[1],"researchers":[2],"have":[3],"studied":[4],"extensively":[5],"the":[6,20,34,69,93,107,113,120,154],"mistakes":[7,21,42,73,95,117],"of":[8,22,39,47,55,82,115,119,124,157],"novice":[9],"programmers.":[10],"In":[11],"comparison,":[12],"little":[13],"attention":[14],"has":[15],"been":[16],"given":[17],"to":[18,101,147],"studying":[19],"people":[23],"who":[24],"are":[25,118],"novices":[26],"at":[27],"writing":[28,44,79],"database":[29],"queries.":[30],"This":[31],"paper":[32],"represents":[33],"first":[35],"large":[36],"scale":[37],"analysis":[38],"students'":[40],"semantic":[41,72,94,103,116],"in":[43,98,106,128],"different":[45,80,102],"types":[46,81],"SQL":[48,56,83,162],"SELECT":[49],"statements.":[50],"Over":[51],"160":[52],"thousand":[53],"snapshots":[54],"queries":[57,129],"were":[58],"collected":[59],"from":[60],"over":[61],"2300":[62],"students":[63,76,150],"across":[64],"nine":[65],"years.":[66],"We":[67,91,141],"describe":[68],"most":[70],"common":[71],"that":[74,112,130,143],"these":[75,125],"made":[77],"when":[78,159],"statements,":[84],"and":[85],"suggest":[86],"reasons":[87],"behind":[88],"those":[89],"mistakes.":[90],"mapped":[92],"we":[96],"identified":[97],"our":[99],"data":[100],"categories":[104],"found":[105],"literature.":[108],"Our":[109],"findings":[110],"show":[111],"majority":[114],"type":[121,156],"\"omission\".":[122],"Most":[123],"omissions":[126],"happen":[127],"require":[131],"a":[132,134,137,161],"JOIN,":[133],"subquery,":[135],"or":[136],"GROUP":[138],"BY":[139],"operator.":[140],"conclude":[142],"it":[144],"is":[145],"important":[146],"explicitly":[148],"teach":[149],"techniques":[151],"for":[152],"choosing":[153],"appropriate":[155],"query":[158],"designing":[160],"query.":[163]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":7},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":18},{"year":2022,"cited_by_count":8},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}