Numărul de untăți de învățământ preuniversitar de stat și private per limbi străine pentru anul școlar 2020-2021 / Unitati inv preuniv per limbi straine_an 2020-2021.xlsx

SQL select dc.code "Judet", dlev.description "Nivel", dl1.description "Limba 1", null "Limba 2", count(distinct(s.id_school)) "Nr. unitati" from asoc_student a inner join study_formation sf on sf.id_study_formation=a.id_Study_formation and a.id_study_status=4 inner join school s on s.id_school=sf.id_school and s.internal_state=0 and s.id_School_year=23 inner join dd_county dc on dc.id_county=s.id_county inner join dd_level dlev on dlev.id_dd_level=sf.id_dd_level left join dd_discipline dl1 on dl1.id_discipline=a.id_f_language group by dc.code, dlev.description, null, dl1.description union all select dc.code "Judet", dlev.description "Nivel", null "Limba 1", dl2.description "Limba 2", count(distinct(s.id_school)) "Nr. unitati" from asoc_student a inner join study_formation sf on sf.id_study_formation=a.id_Study_formation and a.id_study_status=4 inner join school s on s.id_school=sf.id_school and s.internal_state=0 and s.id_School_year=23 inner join dd_county dc on dc.id_county=s.id_county inner join dd_level dlev on dlev.id_dd_level=sf.id_dd_level left join dd_discipline dl2 on dl2.id_discipline=a.id_s_language group by dc.code, dlev.description, null, dl2.description order by 1,2 Sheet3 Limba 1 Limba 2 Preșcolar Preșcolar Total Primar Primar Total Gimnazial Gimnazial Total Liceal Liceal Total Postliceal Postliceal Total Profesional Profesional Total Grand Total Preșcolar Preșcolar Total Primar Primar Total Gimnazial Gimnazial Total Liceal Liceal Total Postliceal Postliceal Total Profesional Profesional Total Grand Total Judet Limba engleza Limba franceza Limba germana Limba italiana Limba engleza Limba franceza Limba germana Limba italiana Limba spaniola Limba engleza Limba franceza Limba germana Limba italiana Limba spaniola Limba chineza Limba engleza Limba franceza Limba germana Limba italiana Limba japoneza Limba portugheza Limba rusa Limba spaniola Limba turca Limba engleza Limba franceza Limba germana Limba rusa Limba spaniola Limba engleza Limba franceza Limba germana Limba spaniola Limba engleza Limba franceza Limba germana Limba engleza Limba franceza Limba germana Limba rusa Limba spaniola Limba chineza Limba engleza Limba franceza Limba germana Limba italiana Limba rusa Limba spaniola Limba turca Limba chineza Limba engleza Limba franceza Limba germana Limba greaca Limba italiana Limba japoneza Limba rusa Limba spaniola Limba turca Limba engleza Limba franceza Limba germana Limba italiana Limba spaniola Limba engleza Limba franceza Limba germana Limba italiana Limba rusa Limba spaniola AB 8 8 205 38 8 251 128 40 13 181 34 10 3 47 7 7 19 7 26 520 5 9 1 15 40 116 29 185 14 31 11 2 58 6 19 7 32 290 AG 19 6 2 27 211 158 10 379 165 129 7 301 39 38 3 1 81 10 4 14 20 17 37 839 3 3 6 32 26 5 63 103 145 36 9 293 38 39 14 6 1 98 1 5 1 7 18 20 2 40 507 AR 38 1 1 40 182 36 14 232 132 31 19 1 183 40 15 3 58 4 1 5 23 6 1 30 548 2 20 3 25 26 109 28 1 1 165 12 39 22 1 74 1 1 5 15 10 30 295 B 32 1 1 34 240 110 93 1 25 469 237 116 87 7 23 470 2 119 55 14 6 2 5 7 1 211 27 7 1 1 1 37 32 5 1 38 1259 2 2 19 43 16 2 80 115 215 90 11 1 16 4 452 2 73 115 47 12 1 2 29 9 290 2 7 9 2 27 2 31 864 BC 44 4 48 280 106 1 387 217 91 3 311 35 16 1 52 10 10 20 7 1 28 836 4 4 4 33 37 65 200 16 2 283 19 35 9 4 1 68 1 2 3 8 19 1 1 29 424 BH 27 27 303 14 6 1 324 201 13 5 1 1 221 51 8 1 60 12 12 21 21 665 1 1 1 16 3 20 16 151 40 3 1 211 8 45 29 8 1 91 1 3 1 1 6 2 12 9 23 352 BN 6 1 7 148 42 13 203 96 44 15 155 27 7 5 39 6 1 2 9 18 2 2 22 435 3 2 5 34 89 16 4 143 9 26 11 5 1 52 1 2 1 4 4 17 2 23 227 BR 3 2 5 94 54 6 154 86 49 3 138 20 13 5 3 41 7 1 8 11 4 1 16 362 10 9 3 22 42 79 13 134 12 20 7 8 47 2 4 6 7 11 18 227 BT 5 4 9 212 167 1 380 138 104 242 28 16 44 4 4 21 12 33 712 1 1 2 13 16 29 98 133 15 246 15 28 4 1 48 1 1 10 20 30 356 BV 6 6 157 36 32 1 226 128 36 26 2 192 40 18 10 1 69 12 6 18 22 6 5 33 544 8 14 3 25 33 108 65 1 207 19 40 22 1 1 83 1 3 4 8 17 5 30 349 BZ 6 6 190 105 3 298 146 95 5 246 29 20 49 11 2 13 18 13 31 643 19 13 32 90 134 6 1 231 20 28 5 53 10 16 26 342 CJ 17 3 2 1 23 223 27 31 15 296 171 41 27 3 12 254 67 13 9 6 2 3 100 15 5 20 22 3 25 718 15 15 13 43 1 45 139 49 6 5 1 246 28 61 30 9 5 133 2 5 1 8 4 20 5 29 459 CL 19 2 21 119 47 1 2 169 92 49 1 2 144 16 6 22 3 3 10 1 11 370 4 4 8 19 1 28 39 86 1 1 2 129 6 15 1 22 1 10 11 194 CS 9 2 11 150 72 19 241 106 57 21 3 187 27 17 10 54 9 4 4 17 15 5 1 21 531 3 9 12 38 82 34 1 155 17 25 14 56 1 1 3 9 3 15 239 CT 27 1 28 184 91 19 294 157 86 21 1 265 60 24 6 3 6 99 18 2 20 38 10 1 49 755 1 6 7 19 36 5 60 78 146 39 4 3 270 32 60 14 7 8 9 130 1 5 1 7 11 37 1 49 523 CV 6 6 135 1 7 143 78 4 6 88 18 18 4 4 9 1 10 269 2 5 7 9 27 41 2 79 9 16 1 26 2 4 7 1 14 126 DB 10 1 11 170 93 263 152 84 3 1 240 28 24 2 1 55 9 4 13 15 9 24 606 4 4 3 25 28 85 146 14 1 246 24 28 5 1 1 59 1 5 6 10 16 1 27 370 DJ 14 3 17 214 138 8 1 361 155 124 4 283 41 38 3 5 87 25 4 29 24 19 43 820 3 3 6 13 28 1 42 108 145 28 1 5 287 37 41 5 2 1 86 2 5 7 20 24 44 472 GJ 6 4 10 173 75 1 249 111 57 2 170 31 25 56 11 6 17 19 11 30 532 4 1 5 9 32 41 45 108 12 165 24 31 3 58 2 3 5 9 19 28 302 GL 31 1 32 167 29 1 197 160 49 6 215 35 12 2 1 50 17 1 18 20 5 25 537 7 26 1 34 40 149 21 210 16 34 7 57 6 6 4 17 1 22 329 GR 6 10 16 96 88 1 185 82 63 145 11 9 1 21 1 1 2 4 2 6 375 2 1 3 10 18 28 55 77 2 134 7 11 3 21 1 4 5 191 HD 12 12 158 21 3 182 89 23 3 1 116 32 10 3 2 1 48 19 4 23 21 3 24 405 6 6 3 20 23 23 85 15 2 2 127 15 31 7 6 2 61 3 7 1 11 2 20 5 4 1 32 260 HR 18 18 224 5 28 257 131 3 18 152 38 4 9 51 10 1 11 19 3 22 511 1 2 3 7 21 29 2 59 13 19 31 2 65 3 9 15 27 154 IF 17 17 110 38 8 2 158 82 40 4 1 127 22 13 2 37 3 2 5 4 3 7 351 1 1 6 17 5 28 34 74 10 1 2 121 15 19 1 2 37 2 2 4 3 4 7 198 IL 7 7 90 64 154 83 52 1 136 17 10 2 29 2 1 3 14 3 17 346 2 2 7 13 20 44 79 3 126 11 17 3 1 1 33 1 1 3 14 17 199 IS 41 12 53 347 170 12 529 237 119 11 367 48 29 7 1 5 2 92 10 3 13 40 18 58 1112 7 1 2 10 19 25 6 50 109 222 23 5 2 361 33 46 15 1 4 17 2 118 1 4 5 19 37 56 600 MH 12 1 13 122 51 3 176 91 49 4 3 147 18 15 33 7 4 11 9 7 16 396 2 2 7 6 13 37 74 9 1 5 126 14 19 5 2 40 1 4 5 6 9 1 16 202 MM 38 1 2 41 215 37 11 263 166 36 10 212 41 21 8 2 1 2 75 5 5 26 5 1 32 628 4 4 6 31 5 2 44 2 36 136 23 4 3 204 26 34 19 4 7 3 93 2 2 5 22 3 5 35 382 MS 15 15 330 25 25 380 194 20 27 241 36 11 12 4 63 16 4 20 25 1 2 28 747 1 17 7 25 29 129 65 2 2 227 20 35 24 2 3 1 85 3 3 3 23 7 1 34 374 NT 12 12 196 49 1 246 159 55 7 221 37 18 55 8 2 10 21 9 1 31 575 6 24 30 45 152 11 208 16 37 5 1 2 61 1 1 9 17 2 1 29 329 OT 16 4 20 167 95 7 1 270 146 108 5 1 260 30 26 3 59 9 7 1 17 18 11 29 655 14 24 38 78 127 19 224 28 30 9 67 5 3 1 9 9 17 26 364 PH 13 1 14 265 104 17 1 387 229 113 18 1 361 44 36 7 1 88 13 13 33 13 46 909 2 2 10 37 7 54 85 209 29 1 3 327 37 44 9 1 91 4 4 11 30 1 42 520 SB 16 2 1 19 173 24 14 1 212 134 26 21 181 33 9 10 52 6 6 22 2 2 26 496 1 3 4 8 18 11 1 38 30 91 69 190 15 30 23 2 70 1 1 2 13 8 1 24 327 SJ 5 1 6 128 33 8 169 91 35 8 134 22 9 3 34 5 5 15 1 16 364 8 8 24 70 11 105 11 21 10 42 2 2 2 13 3 18 175 SM 7 1 8 133 5 21 159 113 12 23 148 29 1 7 37 10 5 1 16 16 2 18 386 1 1 1 5 6 11 79 39 129 6 24 12 4 1 47 3 3 15 4 19 205 SV 20 2 22 292 156 16 464 225 121 14 360 42 27 6 75 8 3 11 30 12 1 43 975 1 1 8 33 1 42 97 196 43 1 1 338 30 42 21 2 4 99 1 5 6 10 26 11 47 533 TL 13 2 15 93 31 1 125 77 36 113 18 8 2 28 2 2 13 2 15 298 1 1 3 8 11 30 71 1 102 8 17 3 28 2 11 13 155 TM 15 1 1 17 240 50 36 4 330 172 56 26 254 58 14 8 2 2 84 8 2 10 24 3 4 31 726 1 1 2 4 9 11 24 49 131 81 6 267 18 54 31 7 1 1 1 113 1 1 2 6 21 10 37 445 TR 10 5 15 99 82 1 1 183 89 71 160 18 16 34 3 3 7 6 13 408 2 2 4 6 12 18 60 75 1 136 17 19 2 38 1 1 6 6 12 209 VL 36 2 38 161 34 2 197 128 47 8 183 25 11 36 8 1 9 16 7 23 486 10 10 6 34 5 45 33 117 17 167 14 25 6 45 1 1 6 13 19 287 VN 15 2 17 176 75 251 113 69 1 183 21 15 36 7 3 10 10 4 14 511 1 2 3 8 23 31 47 101 6 154 17 21 4 2 1 45 1 4 5 4 10 14 252 VS 26 8 34 234 187 2 3 1 427 147 131 1 1 2 282 21 16 3 2 1 43 3 3 15 9 1 25 814 1 3 4 17 17 34 101 124 5 3 233 17 21 2 5 8 53 10 14 1 25 349 Grand Total 703 84 15 3 805 7806 2863 491 4 56 11220 5834 2584 484 18 49 8969 2 1446 703 163 30 3 7 12 34 2 2402 384 90 10 1 1 486 799 263 29 2 1093 24975 30 68 3 101 344 794 118 2 3 1261 3 2213 4947 1103 67 6 58 5 8402 2 811 1366 518 1 96 1 44 80 22 2941 32 107 4 3 1 147 266 697 126 7 5 4 1105 13957