{"id":"W4386719007","doi":"10.1145/3568812.3603471","title":"MSMI1: Towards a Validated SQL Misconceptions Instrument","year":2023,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Toronto","funders":"","keywords":"Computer science; SQL; SQL/PSM; Database; World Wide Web; Query by Example","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.02413727,0.001292296,0.0007697528,0.005711253,0.001260118,0.004886196,0.002730598,0.001756322,0.006168644],"category_scores_gemma":[0.08426537,0.0006968892,0.000867496,0.002587235,0.001479089,0.005256058,0.007438846,0.002534599,0.006715024],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001714509,"about_ca_system_score_gemma":0.006234679,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003191638,"about_ca_topic_score_gemma":0.002896324,"domain_scores_codex":[0.9754023,0.006551389,0.003037291,0.002613108,0.01133355,0.001062428],"domain_scores_gemma":[0.9265538,0.02559207,0.008019219,0.008560057,0.02889656,0.002378314],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"observational","study_design_scores_codex":[0.003417634,0.002834464,0.2494877,0.002792431,0.0006190274,0.0003688858,0.007099645,0.006981601,0.05116891,0.05829696,0.1442599,0.4726728],"study_design_scores_gemma":[0.0005273651,0.003820604,0.1360354,0.002333314,0.0008407995,0.001375961,0.006739846,0.1751831,0.2286808,0.04460112,0.3991219,0.000739723],"study_design_candidate":"observational","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.2156419,0.0006492048,0.6044878,0.004440657,0.0005335896,0.004818518,0.0514852,0.08233312,0.03561006],"genre_scores_gemma":[0.4173127,0.000305832,0.4721406,0.002376364,0.0002065666,0.00402235,0.0883206,0.003411308,0.01190368],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.02413727,"threshold_uncertainty_score":0.1276516,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04383012856794518,"score_gpt":0.2846854110350373,"score_spread":0.2408552824670921,"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."}}