{"id":"W4391584344","doi":"10.1145/3631802.3631821","title":"“There is no ambiguity on what to return”: Investigating the Prevalence of SQL Misconceptions","year":2023,"lang":"en","type":"article","venue":"","topic":"Scientific Computing and Data Management","field":"Decision Sciences","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Toronto","funders":"","keywords":"Ambiguity; Computer science; SQL; Programming language","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.02688086,0.0003623126,0.000668769,0.005387206,0.0009022983,0.00268348,0.001596038,0.001386808,0.001768147],"category_scores_gemma":[0.1888565,0.0005272646,0.0004978345,0.0025453,0.002725667,0.004156275,0.003255385,0.00156279,0.0003769227],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001172309,"about_ca_system_score_gemma":0.001744421,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002507768,"about_ca_topic_score_gemma":0.002021427,"domain_scores_codex":[0.9781187,0.00868101,0.00348369,0.00164386,0.007197297,0.0008754559],"domain_scores_gemma":[0.7314596,0.1839818,0.05755962,0.007033807,0.0166145,0.003350629],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"observational","study_design_gemma":"observational","study_design_scores_codex":[0.0002145712,0.0002318036,0.9099497,0.0002910861,0.00008145712,0.000359203,0.05538737,0.0001347861,0.0008280742,0.0004886945,0.0004539732,0.03157922],"study_design_scores_gemma":[0.00003864836,0.0007591228,0.8055826,0.0008914456,0.0001911359,0.006152051,0.1703733,0.003586181,0.003575591,0.001969828,0.006735559,0.0001443273],"study_design_candidate":"observational","study_design_consensus":"observational","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9982737,0.0001685375,0.0006439796,0.0002477095,0.00000661992,0.00002741289,0.00004691951,0.00001316987,0.0005717989],"genre_scores_gemma":[0.9983736,0.0002182662,0.0009404346,0.0001257215,0.000008444411,0.00003554098,0.0000867253,0.000008599244,0.0002026645],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.02688086,"threshold_uncertainty_score":0.1421613,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.2597451312194503,"score_gpt":0.4234667037507703,"score_spread":0.16372157253132,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}