{"id":"https://openalex.org/W3214115509","doi":"https://doi.org/10.1145/3488042.3489961","title":"Exploring the Prevalence of SQL Misconceptions: a Study Design","display_name":"Exploring the Prevalence of SQL Misconceptions: a Study Design","publication_year":2021,"publication_date":"2021-11-10","ids":{"openalex":"https://openalex.org/W3214115509","doi":"https://doi.org/10.1145/3488042.3489961","mag":"3214115509"},"language":"en","primary_location":{"id":"doi:10.1145/3488042.3489961","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3488042.3489961","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st Koli Calling International Conference on Computing Education Research","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://pure.tue.nl/ws/files/191839423/poster_abstract.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","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":["AIDE Lab, Eindhoven University of Technology, Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AIDE Lab, Eindhoven University of Technology, Netherlands","institution_ids":["https://openalex.org/I83019370"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047667810","display_name":"Efthimia Aivaloglou","orcid":"https://orcid.org/0000-0002-6531-2166"},"institutions":[{"id":"https://openalex.org/I121797337","display_name":"Leiden University","ror":"https://ror.org/027bh9e22","country_code":"NL","type":"education","lineage":["https://openalex.org/I121797337"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Efthimia Aivaloglou","raw_affiliation_strings":["Leiden Institute of Advanced Computer Science, Leiden University, Netherlands and Open Universiteit, Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Leiden Institute of Advanced Computer Science, Leiden University, Netherlands and Open Universiteit, Netherlands","institution_ids":["https://openalex.org/I121797337"]}]},{"author_position":"last","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":["AIDE Lab, Eindhoven University of Technology, Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AIDE Lab, Eindhoven University of Technology, Netherlands","institution_ids":["https://openalex.org/I83019370"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.18622338,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"14","issue":null,"first_page":"1","last_page":"3"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9962000250816345,"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.9962000250816345,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9821000099182129,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9793999791145325,"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","display_name":"SQL","score":0.8300893306732178},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7947616577148438},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.6272218823432922},{"id":"https://openalex.org/keywords/curriculum","display_name":"Curriculum","score":0.5674137473106384},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4572269022464752},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4530283808708191},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.4345020651817322},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3316059410572052},{"id":"https://openalex.org/keywords/mathematics-education","display_name":"Mathematics education","score":0.331092894077301},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.28368836641311646},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2708006203174591},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.17582005262374878},{"id":"https://openalex.org/keywords/pedagogy","display_name":"Pedagogy","score":0.12620526552200317}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8300893306732178},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7947616577148438},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6272218823432922},{"id":"https://openalex.org/C47177190","wikidata":"https://www.wikidata.org/wiki/Q207137","display_name":"Curriculum","level":2,"score":0.5674137473106384},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4572269022464752},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4530283808708191},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4345020651817322},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3316059410572052},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.331092894077301},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.28368836641311646},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2708006203174591},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.17582005262374878},{"id":"https://openalex.org/C19417346","wikidata":"https://www.wikidata.org/wiki/Q7922","display_name":"Pedagogy","level":1,"score":0.12620526552200317},{"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/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3488042.3489961","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3488042.3489961","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st Koli Calling International Conference on Computing Education Research","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.tue.nl:openaire_cris_publications/22765f90-fbd7-4b3a-a564-223bd2c175b1","is_oa":true,"landing_page_url":"https://research.tue.nl/en/publications/22765f90-fbd7-4b3a-a564-223bd2c175b1","pdf_url":"https://pure.tue.nl/ws/files/191839423/poster_abstract.pdf","source":{"id":"https://openalex.org/S4406922641","display_name":"TU/e Research Portal","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Miedema, D E, Aivaloglou, E & Fletcher, G H L 2021, Exploring the Prevalence of SQL Misconceptions : a Study Design. in O Sepp\u00e4l\u00e4 & A Petersen (eds), Koli Calling '21 : Proceedings of the 21st Koli Calling International Conference on Computing Education Research., 36, Association for Computing Machinery, Inc., New York, 21st Koli Calling International Conference on Computing Education Research, Koli Calling 2021, Joensuu, Finland, 18/11/21. https://doi.org/10.1145/3488042.3489961","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:scholarlypublications.universiteitleiden.nl:item_3250268","is_oa":false,"landing_page_url":"https://hdl.handle.net/1887/3250268","pdf_url":null,"source":{"id":"https://openalex.org/S4306400850","display_name":"Leiden Repository (Leiden University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I121797337","host_organization_name":"Leiden University","host_organization_lineage":["https://openalex.org/I121797337"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"21st Koli calling international conference on computing education research","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:ul:oai:scholarlypublications.universiteitleiden.nl:item_3250268","is_oa":false,"landing_page_url":"http://hdl.handle.net/1887/3250268","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"21st Koli calling international conference on computing education research, 1 - 3. New York: Association for Computing Machinery","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:pure.tue.nl:openaire_cris_publications/22765f90-fbd7-4b3a-a564-223bd2c175b1","is_oa":true,"landing_page_url":"https://research.tue.nl/en/publications/22765f90-fbd7-4b3a-a564-223bd2c175b1","pdf_url":"https://pure.tue.nl/ws/files/191839423/poster_abstract.pdf","source":{"id":"https://openalex.org/S4406922641","display_name":"TU/e Research Portal","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Miedema, D E, Aivaloglou, E & Fletcher, G H L 2021, Exploring the Prevalence of SQL Misconceptions : a Study Design. in O Sepp\u00e4l\u00e4 & A Petersen (eds), Koli Calling '21 : Proceedings of the 21st Koli Calling International Conference on Computing Education Research., 36, Association for Computing Machinery, Inc., New York, 21st Koli Calling International Conference on Computing Education Research, Koli Calling 2021, Joensuu, Finland, 18/11/21. https://doi.org/10.1145/3488042.3489961","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.4399999976158142,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3214115509.pdf","grobid_xml":"https://content.openalex.org/works/W3214115509.grobid-xml"},"referenced_works_count":21,"referenced_works":["https://openalex.org/W1964523235","https://openalex.org/W1977085035","https://openalex.org/W2002515044","https://openalex.org/W2005747652","https://openalex.org/W2096431252","https://openalex.org/W2132516581","https://openalex.org/W2139617990","https://openalex.org/W2286501037","https://openalex.org/W2473995384","https://openalex.org/W2768875651","https://openalex.org/W2774208773","https://openalex.org/W2809284492","https://openalex.org/W2885048964","https://openalex.org/W2885090162","https://openalex.org/W2897557400","https://openalex.org/W2916040897","https://openalex.org/W3009770877","https://openalex.org/W3033482208","https://openalex.org/W3041823931","https://openalex.org/W3110179358","https://openalex.org/W3193751197"],"related_works":["https://openalex.org/W650213220","https://openalex.org/W1980548249","https://openalex.org/W2340883001","https://openalex.org/W2348171219","https://openalex.org/W2042813897","https://openalex.org/W2974218799","https://openalex.org/W20807724","https://openalex.org/W1984237344","https://openalex.org/W4366683866","https://openalex.org/W2486394024"],"abstract_inverted_index":{"The":[0],"Structured":[1],"Query":[2],"Language":[3],"(SQL)":[4],"is":[5,16,50],"an":[6],"established":[7],"language":[8,49],"for":[9,76],"data":[10],"manipulation":[11],"in":[12,19],"relational":[13],"databases.":[14],"It":[15],"widely":[17],"used":[18],"industry,":[20],"and":[21,42,66,112,116],"therefore":[22],"part":[23],"of":[24,34,61,94],"the":[25,31,59,68,73,92,102],"typical":[26],"Computer":[27,103],"Science":[28,104],"curriculum.":[29],"From":[30],"large":[32],"amounts":[33],"mistakes":[35,62,78],"higher":[36],"education":[37],"students":[38],"make":[39],"while":[40],"learning":[41],"using":[43],"SQL,":[44],"we":[45,86],"know":[46],"that":[47],"this":[48,83],"not":[51],"easy":[52],"to":[53,90],"learn.":[54],"Various":[55],"researchers":[56],"have":[57],"examined":[58],"types":[60],"SQL":[63],"novices":[64],"make,":[65],"recently,":[67],"first":[69],"step":[70],"towards":[71],"understanding":[72],"underlying":[74],"reasons":[75],"these":[77,95],"has":[79],"been":[80],"made.":[81],"In":[82],"poster":[84],"abstract,":[85],"propose":[87],"a":[88],"study":[89],"examine":[91],"prevalence":[93],"origins,":[96],"also":[97],"called":[98],"misconceptions.":[99],"We":[100],"hope":[101],"Education":[105],"community":[106],"will":[107],"help":[108],"us":[109],"reflect":[110],"on":[111],"strengthen":[113],"our":[114,118],"methodology,":[115],"ultimately,":[117],"findings.":[119]},"counts_by_year":[],"updated_date":"2026-08-01T09:00:35.917206","created_date":"2025-10-10T00:00:00"}