Numărul de elevi din învățământul preuniversitar care studiază limbi străine pentru anul școlar 2020-2021 / Nr. Elevi per limbi straine si nivel_an 2020-2021.xlsx

SQL select dc.code "Judet", dlev.description "Nivel", dl1.description "Limba 1", null "Limba 2", count(distinct(a.id_student)) "Nr. elevi" 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(a.id_student)) "Nr. elevi" 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 Sheet2 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 38 38 12133 620 488 13241 10206 938 389 11533 9708 888 47 10643 203 203 1687 336 2023 37681 174 27 20 221 978 6472 1581 9031 928 7834 1614 57 10433 315 1229 245 1789 21474 AG 126 6 75 207 18116 5156 361 23633 15965 4818 253 21036 14569 3614 50 1 18234 313 158 471 1457 1035 2492 66073 76 5 81 952 428 90 1470 3430 10101 894 216 14641 3494 12914 1111 388 28 17935 6 149 5 160 1011 1363 16 2390 36677 AR 555 1 1 557 13198 466 109 13773 12883 351 147 1 13382 8192 518 32 8742 269 13 282 1223 29 2 1254 37990 10 216 161 387 211 4755 1004 1 1 5972 474 5394 799 1 6668 1 1 7 665 449 1121 14149 B 972 1 1 974 67514 2805 4140 319 1002 75780 54659 2895 3457 432 790 62233 87 55475 2004 621 284 87 117 405 1 59081 3158 370 27 1 56 3612 3434 119 28 3581 205261 247 247 291 738 394 32 1455 4789 30959 4213 346 1 783 191 41282 118 3090 46829 2526 509 114 86 1400 826 55498 70 198 268 47 2824 122 2993 101743 BC 379 6 385 23910 2986 1 26897 20396 2529 3 22928 16968 666 5 17639 1122 1122 3543 345 1 3889 72860 48 48 14 189 203 1693 14965 1031 3 17692 679 15498 764 208 221 17370 1 127 128 346 3417 1 1 3765 39206 BH 60 60 25244 55 110 1 25410 20601 89 121 1 1 20813 15648 8 57 15713 753 753 2905 2905 65654 1 1 5 187 3 195 75 9585 3202 16 90 12968 68 9491 4235 234 42 14070 1 190 18 1 210 8 1730 466 2204 29648 BN 21 19 40 11850 1039 368 13257 9771 964 445 11180 6893 476 210 7579 580 4 61 645 1856 124 68 2048 34749 9 3 12 981 4791 1070 76 6918 511 4699 1057 283 1 6551 3 28 3 34 166 1579 2 1747 15262 BR 3 2 5 9194 1774 164 11132 8681 1830 89 10600 7578 747 82 3 8410 573 101 674 1482 349 1 1832 32653 110 118 20 248 1443 6395 763 8601 720 6866 636 21 8243 57 123 180 257 1434 1691 18963 BT 6 6 12 12208 5375 1 17584 10917 4851 15768 10734 1227 11961 743 743 2162 905 3067 49135 3 1 4 151 472 623 3685 8944 298 12927 1225 9936 114 1 11276 110 110 849 2066 2915 27855 BV 9 9 24190 655 1282 1 26128 18561 511 1148 32 20252 11940 1109 376 124 13549 1277 220 1497 2757 295 363 3415 64850 65 226 14 305 1155 8973 3447 1 13576 1464 7141 1962 1 1 10569 16 64 80 512 1865 303 2680 27210 BZ 32 32 14423 2846 18 17287 12136 3258 94 15488 9982 2027 12009 966 119 1085 1605 713 2318 48219 210 71 281 2475 8768 312 85 11640 2016 9280 361 11657 692 1566 2258 25836 CJ 164 14 61 1 240 22087 293 771 511 23662 19968 527 945 30 178 21648 13088 471 279 177 56 193 14264 502 129 631 1733 145 1878 62323 300 47 191 538 1 1022 7547 1547 201 174 5 10497 1180 10021 1579 356 126 13262 3 137 4 144 146 1274 128 1548 25989 CL 136 6 142 11157 1096 1 2 12256 9730 1028 1 2 10761 4883 816 5699 168 168 1147 203 1350 30376 46 46 103 598 1 702 583 6940 1 1 3 7528 817 4310 1 5128 203 1057 1260 14664 CS 42 2 44 7217 933 534 8684 6229 1319 508 55 8111 5756 1072 200 7028 464 150 224 838 907 55 20 982 25687 27 61 88 933 2581 1233 1 4748 846 2675 1239 4760 42 42 14 417 86 517 10155 CT 497 25 522 26499 2691 1285 30475 22424 2459 659 1 25543 18957 729 263 125 154 20228 1218 557 1775 2576 240 1 2817 81360 25 106 131 204 600 44 848 2225 13099 2518 86 36 17964 1270 16073 1211 116 97 179 18946 6 138 1 145 228 2390 15 2633 40667 CV 8 8 8795 1 227 9023 7674 4 119 7797 4605 4605 146 146 1249 6 1255 22834 17 7 24 115 1063 2516 10 3704 1239 3103 74 4416 2 187 872 1 1062 9206 DB 24 1 25 15843 4487 20330 12951 3909 55 1 16916 10267 3544 4 74 13889 861 174 1035 1664 827 2491 54686 4 4 118 486 604 3661 11544 500 1 15706 3633 9930 222 1 1 13787 147 118 265 826 1587 1 2414 32780 DJ 83 5 88 20544 4961 294 1 25800 15501 4333 142 19976 14751 4261 164 242 19418 2632 208 2840 1762 900 2662 70784 5 5 10 221 357 28 606 3409 10799 2464 19 97 16788 4594 13597 706 53 74 19024 154 278 432 817 1586 2403 39263 GJ 7 11 18 10688 982 1 11671 9868 1266 2 11136 9243 1727 10970 660 411 1071 1041 352 1393 36259 11 1 12 57 507 564 774 6622 528 7924 1507 8015 323 9845 56 98 154 313 864 1177 19676 GL 276 3 279 19997 520 43 20560 17912 852 166 18930 15646 1021 83 1 16751 1914 88 2002 2063 357 2420 60942 22 204 75 301 801 13367 783 14951 1102 14559 713 16374 495 495 307 1741 49 2097 34218 GR 35 61 96 6696 4183 1 10880 5837 3404 9241 3145 1388 1 4534 62 19 81 289 53 342 25174 2 1 3 257 183 440 2247 3569 52 5868 1068 2718 379 4165 50 264 314 10790 HD 45 45 13082 156 3 13241 12462 308 17 1 12788 10542 473 49 50 1 11115 2211 92 2303 2277 58 2335 41827 12 12 37 391 428 255 8976 913 64 20 10228 609 8531 322 588 73 10123 90 449 28 567 13 1872 62 98 7 2052 23410 HR 134 134 14373 40 768 15181 11567 72 666 12305 8195 23 462 8680 478 1 479 2128 61 2189 38968 1 3 4 273 1359 1690 131 3453 452 2079 5410 2 7943 61 198 1552 1811 13211 IF 492 492 17826 2116 9 131 20082 12710 1750 4 106 14570 5494 1151 153 6798 233 33 266 596 54 650 42858 32 32 398 718 143 1259 1710 11501 296 1 73 13581 1278 4194 42 97 5611 33 55 88 54 503 557 21128 IL 46 46 7774 2691 10465 7240 1954 1 9195 4768 832 30 5630 7 1 8 1051 26 1077 26421 14 14 69 169 238 1507 5219 150 6876 809 4138 57 84 1 5089 5 5 26 1017 1043 13265 IS 412 117 529 32246 5903 354 38503 26574 5453 674 32701 20383 2715 294 1 30 53 23476 1494 237 1731 5037 819 5856 102796 111 1 82 194 505 651 157 1313 5424 21899 2387 167 93 29970 2916 16239 2077 16 144 126 28 21546 4 166 170 825 4401 5226 58419 MH 118 5 123 7380 839 3 8222 6332 977 42 4 7355 6464 1718 8182 425 359 784 396 219 615 25281 12 12 43 125 168 524 3531 187 24 83 4349 1617 5514 669 155 7955 13 82 95 179 328 55 562 13141 MM 150 1 36 187 16737 852 318 17907 14449 938 156 15543 12550 1088 102 30 1 58 13829 249 249 1498 237 31 1766 49481 5 5 25 703 54 28 810 30 636 6539 1129 103 110 8547 1048 8504 1170 162 158 131 11173 22 22 225 994 20 228 1467 22024 MS 78 78 24185 346 749 25280 19043 391 825 20259 12854 231 517 73 13675 901 140 1041 2344 92 3 2439 62772 27 122 92 241 698 7089 3419 2 14 11222 652 7951 3087 56 118 1 11865 73 73 93 1862 200 22 2177 25578 NT 72 72 18447 1046 1 19494 15373 1211 360 16944 12432 879 13311 435 29 464 2313 379 115 2807 53092 17 681 698 1211 11641 497 13349 680 9846 508 1 165 11200 2 2 262 1274 214 1 1751 27000 OT 128 11 139 11875 2222 49 1 14147 10667 2618 66 1 13352 8443 3376 4 11823 799 345 1 1145 1077 691 1768 42374 184 252 436 1479 5740 551 7770 2779 6060 349 9188 166 5 2 173 534 819 1353 18920 PH 122 1 123 25427 2213 427 1 28068 23111 2111 375 1 25598 16630 2135 158 57 18980 687 687 2657 337 2994 76450 2 2 128 501 82 711 1652 14245 1462 1 159 17519 2071 14757 805 1 17634 80 80 279 2459 2 2740 38686 SB 84 14 3 101 17468 444 353 1 18266 14000 450 434 14884 7994 60 250 8304 273 273 1532 13 16 1561 43389 13 3 16 162 154 38 1 355 604 4756 3903 9263 281 2579 1860 80 4800 55 55 16 615 304 1 936 15425 SJ 9 1 10 9592 748 221 10561 7499 725 225 8449 6305 371 9 6685 223 223 978 24 1002 26930 107 107 580 4225 547 5352 370 4428 1028 5826 36 36 25 831 79 935 12256 SM 104 9 113 14038 288 866 15192 11370 272 600 12242 8414 23 490 8927 535 433 50 1018 2332 232 2564 40056 1 1 26 34 60 332 4377 2318 7027 382 5227 1985 208 1 7803 102 102 1539 388 1927 16920 SV 397 7 404 28553 4218 354 33125 22560 3703 329 26592 19053 2540 331 21924 660 215 875 3674 530 12 4216 87136 4 4 70 1079 1 1150 2248 12231 2319 1 1 16800 2756 15668 1831 4 420 20679 1 237 238 461 2637 390 3488 42359 TL 49 2 51 7771 550 1 8322 6704 608 7312 4566 477 3 5046 154 154 738 35 773 21658 1 1 19 105 124 465 4905 3 5373 479 3936 13 4428 28 635 663 10589 TM 88 1 1 90 23693 1104 1479 51 26327 19555 1140 1088 21783 16458 869 445 172 173 18117 2282 6 2288 2875 68 160 3103 71708 1 1 2 23 134 211 368 1500 8223 5047 414 15184 1374 10072 4947 618 32 133 1 17177 280 195 475 180 1850 554 2584 35790 TR 137 74 211 7780 3497 1 1 11279 6685 3529 10214 5534 2773 8307 324 324 447 489 936 31271 44 16 60 202 240 442 2350 4134 1 6485 2275 5184 39 7498 87 87 473 431 904 15476 VL 381 54 435 12032 475 90 12597 10692 537 45 11274 8164 617 8781 445 52 497 1142 274 1416 35000 114 114 29 478 39 546 272 5871 809 6952 620 6176 493 7289 64 64 139 938 1077 16042 VN 153 5 158 11866 2158 14024 9644 1907 1 11552 7705 871 8576 260 37 297 824 189 1013 35620 3 2 5 965 250 1215 1205 5456 387 7048 874 6320 258 116 1 7569 4 157 161 189 728 917 16915 VS 106 26 132 11469 4595 2 97 1 16164 11441 4560 1 45 26 16073 7614 2092 53 35 61 9855 52 52 1945 627 1 2573 44849 1 3 4 36 39 75 2713 6859 5 106 9683 2149 7212 55 103 146 9665 521 1661 1 2183 21610 Grand Total 6778 464 209 3 7454 715117 80425 16247 416 1705 813910 602548 77349 14652 567 1141 696257 87 478590 53627 5581 1050 88 173 38 1731 2 540967 31711 4700 364 1 56 36832 76403 12543 1119 2 90067 2185487 543 439 83 1065 6266 12671 1865 28 33 20863 31 64323 350615 57974 1576 115 2127 196 476957 118 57157 373634 51647 16 4362 114 471 3510 1009 492038 1111 4168 28 33 1 5341 11699 58697 6561 122 228 24 77331 1073595