{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,8,23]],"date-time":"2025-08-23T00:08:07Z","timestamp":1755907687224,"version":"3.44.0"},"publisher-location":"New York, NY, USA","reference-count":59,"publisher":"ACM","license":[{"start":{"date-parts":[[2023,11,13]],"date-time":"2023-11-13T00:00:00Z","timestamp":1699833600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2023,11,13]]},"DOI":"10.1145\/3631802.3631821","type":"proceedings-article","created":{"date-parts":[[2024,2,6]],"date-time":"2024-02-06T12:45:51Z","timestamp":1707223551000},"page":"1-12","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["\u201cThere is no ambiguity on what to return\u201d: Investigating the Prevalence of SQL Misconceptions"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-3507-677X","authenticated-orcid":false,"given":"Daphne","family":"Miedema","sequence":"first","affiliation":[{"name":"Mathematics and Computer Science, Eindhoven University of Technology, Netherlands"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2965-5302","authenticated-orcid":false,"given":"Michael","family":"Liut","sequence":"additional","affiliation":[{"name":"Mathematical and Computational Sciences, University of Toronto Mississauga, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2111-6769","authenticated-orcid":false,"given":"George H. L.","family":"Fletcher","sequence":"additional","affiliation":[{"name":"Mathematics and Computer Science, Eindhoven University of Technology, Netherlands"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-6531-2166","authenticated-orcid":false,"given":"Efthimia","family":"Aivaloglou","sequence":"additional","affiliation":[{"name":"Delft University of Technology, Netherlands"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2024,2,6]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/2839509.2844640"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/2729094.2742620"},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/2899415.2899464"},{"key":"e_1_3_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/3582302.3582314"},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/358172.358408"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.2190\/3LFX-9RRF-67T8-UVK9"},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2005.06.028"},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/2994154"},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/2047594.2047641"},{"volume-title":"Computer Science Education Research","author":"Clancy Michael","key":"e_1_3_2_1_10_1","unstructured":"Michael Clancy. 2004. Computer Science Education Research. Taylor & Francis Group, Chapter Misconceptions and attitudes that interfere with learning to program, 85\u2013100."},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1315803.1315821"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/3437800.3439202"},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/2632320.2632346"},{"volume-title":"viSQLizer: An interactive visualizer for learning SQL. Ph.\u00a0D. Dissertation","author":"Annabel\u00a0Torjussen Folland Kristin","key":"e_1_3_2_1_14_1","unstructured":"Kristin Annabel\u00a0Torjussen Folland. 2016. viSQLizer: An interactive visualizer for learning SQL. Ph.\u00a0D. Dissertation. Norwegian University of Science and Technology."},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/2481449.2481474"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3125659.3125688"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1088\/0031-9120\/34\/5\/304"},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1080\/08993408.2014.970781"},{"key":"e_1_3_2_1_19_1","volume-title":"Force concept inventory. The physics teacher 30, 3","author":"Hestenes David","year":"1992","unstructured":"David Hestenes, Malcolm Wells, and Gregg Swackhamer. 1992. Force concept inventory. The physics teacher 30, 3 (1992), 141\u2013158."},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1207\/s15327809jls0302_1"},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/3197091.3197124"},{"key":"e_1_3_2_1_22_1","volume-title":"How Well Do Multiple Choice Tests Evaluate Student Understanding in Computer Programming Classes?Journal of Information Systems Education 14, 4","author":"Kuechler William","year":"2003","unstructured":"William Kuechler and Mark Simkin. 2003. How Well Do Multiple Choice Tests Evaluate Student Understanding in Computer Programming Classes?Journal of Information Systems Education 14, 4 (2003), 389."},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3389767"},{"key":"e_1_3_2_1_24_1","unstructured":"Linxiao Ma. 2007. Investigating and Improving Novice Programmers\u2019 Mental Models of Programming Concepts. Ph.\u00a0D. Dissertation. Strathclyde. https:\/\/citeseerx.ist.psu.edu\/document?repid=rep1&type=pdf&doi=3c8efb0c95325ac2f6bb38bd3d56fdbe900e4892"},{"key":"e_1_3_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1080\/08993408.2011.554722"},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/3501709.3544282"},{"key":"e_1_3_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/3446871.3469759"},{"key":"e_1_3_2_1_28_1","volume-title":"SQLVis: Visual Query Representations for Supporting SQL Learners. In 2021 IEEE Symposium on Visual Languages and Human-Centric Computing (VL\/HCC).","author":"Miedema Daphne","year":"2021","unstructured":"Daphne Miedema and George Fletcher. 2021. SQLVis: Visual Query Representations for Supporting SQL Learners. In 2021 IEEE Symposium on Visual Languages and Human-Centric Computing (VL\/HCC)."},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/3524610.3529158"},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3568812.3603471"},{"key":"e_1_3_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1109\/SCAM.2017.19"},{"key":"e_1_3_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-05813-5_21"},{"key":"e_1_3_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1007\/s13222-021-00372-0"},{"key":"e_1_3_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/2960310.2960316"},{"key":"e_1_3_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/2445196.2445212"},{"key":"e_1_3_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.2190\/689T-1R2A-X4W4-29J2"},{"key":"e_1_3_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/3291279.3339404"},{"key":"e_1_3_2_1_38_1","doi-asserted-by":"publisher","unstructured":"Kai Presler-Marshall Sarah Heckman and Kathryn\u00a0T Stolee. 2021. SQLRepair: Identifying and Repairing Mistakes in Student-Authored SQL Queries. In 2021 IEEE\/ACM 43rd International Conference on Software Engineering: Software Engineering Education and Training (ICSE- SEET). 199\u2013210. https:\/\/doi.org\/10.1109\/ICSE-SEET52601.2021.00030","DOI":"10.1109\/ICSE-SEET52601.2021.00030"},{"key":"e_1_3_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.2190\/FGN9-DJ2F-86V8-3FAU"},{"key":"e_1_3_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/3077618"},{"key":"e_1_3_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1145\/356835.356837"},{"volume-title":"Measurement of SQL Problems and Progress","author":"Reisner Phyllis","key":"e_1_3_2_1_42_1","unstructured":"Phyllis Reisner. 1986. Measurement of SQL Problems and Progress. Springer-Verlag Tokyo, Nemu-no-sato, Japan, 165\u2013187."},{"key":"e_1_3_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.2190\/UHFF-4LNQ-63VA-Q60C"},{"key":"e_1_3_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/2016911.2016931"},{"key":"e_1_3_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1006\/ijhc.1995.1017"},{"key":"e_1_3_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.1145\/1595356.1595360"},{"volume-title":"Visual Program Simulation in Introductory Programming Education. Ph.\u00a0D. Dissertation","author":"Sorva Juha","key":"e_1_3_2_1_47_1","unstructured":"Juha Sorva. 2012. Visual Program Simulation in Introductory Programming Education. Ph.\u00a0D. Dissertation. Aalto University, Espoo, Finland."},{"key":"e_1_3_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1145\/3230977.3230995"},{"key":"e_1_3_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.1109\/FIE44824.2020.9274114"},{"key":"e_1_3_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1145\/3287324.3287359"},{"key":"e_1_3_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.1145\/3231712"},{"key":"e_1_3_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1080\/00219266.1989.9655083"},{"key":"e_1_3_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/1734263.1734297"},{"key":"e_1_3_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10763-010-9203-x"},{"key":"e_1_3_2_1_55_1","first-page":"190","article-title":"The Development of Three Tier Multiple Choice Test to Explore Junior High School Students \u2019 Scientific Literacy Misconceptions","volume":"8","author":"Wahidah Nurul","year":"2019","unstructured":"Nurul Wahidah and Sigit Saptono. 2019. The Development of Three Tier Multiple Choice Test to Explore Junior High School Students \u2019 Scientific Literacy Misconceptions. Journal of Innovative Science Education 8, 2 (2019), 190\u2013198.","journal-title":"Journal of Innovative Science Education"},{"key":"e_1_3_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.1515\/itit-2018-0010"},{"key":"e_1_3_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.1109\/FIE44824.2020.9273941"},{"key":"e_1_3_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.1145\/3230977.3231005"},{"key":"e_1_3_2_1_59_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10639-018-9824-1"}],"event":{"name":"Koli Calling '23: 23rd Koli Calling International Conference on Computing Education Research","acronym":"Koli Calling '23","location":"Koli Finland"},"container-title":["Proceedings of the 23rd Koli Calling International Conference on Computing Education Research"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3631802.3631821","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3631802.3631821","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,8,22]],"date-time":"2025-08-22T16:20:26Z","timestamp":1755879626000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3631802.3631821"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,11,13]]},"references-count":59,"alternative-id":["10.1145\/3631802.3631821","10.1145\/3631802"],"URL":"https:\/\/doi.org\/10.1145\/3631802.3631821","relation":{},"subject":[],"published":{"date-parts":[[2023,11,13]]},"assertion":[{"value":"2024-02-06","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}