Neumann_Janos_Verseny/fordulo_3/primek.sql
2025-03-12 21:04:26 +01:00

1065 lines
14 KiB
SQL

select id, COUNT(*) as `asd` from primek group by ordered Having asd > 5 order by asd desc;
insert into primek VALUES
(1009,0019),
(1013,0113),
(1019,0119),
(1021,0112),
(1031,0113),
(1033,0133),
(1039,0139),
(1049,0149),
(1051,0115),
(1061,0116),
(1063,0136),
(1069,0169),
(1087,0178),
(1091,0119),
(1093,0139),
(1097,0179),
(1103,0113),
(1109,0119),
(1117,1117),
(1123,1123),
(1129,1129),
(1151,1115),
(1153,1135),
(1163,1136),
(1171,1117),
(1181,1118),
(1187,1178),
(1193,1139),
(1201,0112),
(1213,1123),
(1217,1127),
(1223,1223),
(1229,1229),
(1231,1123),
(1237,1237),
(1249,1249),
(1259,1259),
(1277,1277),
(1279,1279),
(1283,1238),
(1289,1289),
(1291,1129),
(1297,1279),
(1301,0113),
(1303,0133),
(1307,0137),
(1319,1139),
(1321,1123),
(1327,1237),
(1361,1136),
(1367,1367),
(1373,1337),
(1381,1138),
(1399,1399),
(1409,0149),
(1423,1234),
(1427,1247),
(1429,1249),
(1433,1334),
(1439,1349),
(1447,1447),
(1451,1145),
(1453,1345),
(1459,1459),
(1471,1147),
(1481,1148),
(1483,1348),
(1487,1478),
(1489,1489),
(1493,1349),
(1499,1499),
(1511,1115),
(1523,1235),
(1531,1135),
(1543,1345),
(1549,1459),
(1553,1355),
(1559,1559),
(1567,1567),
(1571,1157),
(1579,1579),
(1583,1358),
(1597,1579),
(1601,0116),
(1607,0167),
(1609,0169),
(1613,1136),
(1619,1169),
(1621,1126),
(1627,1267),
(1637,1367),
(1657,1567),
(1663,1366),
(1667,1667),
(1669,1669),
(1693,1369),
(1697,1679),
(1699,1699),
(1709,0179),
(1721,1127),
(1723,1237),
(1733,1337),
(1741,1147),
(1747,1477),
(1753,1357),
(1759,1579),
(1777,1777),
(1783,1378),
(1787,1778),
(1789,1789),
(1801,0118),
(1811,1118),
(1823,1238),
(1831,1138),
(1847,1478),
(1861,1168),
(1867,1678),
(1871,1178),
(1873,1378),
(1877,1778),
(1879,1789),
(1889,1889),
(1901,0119),
(1907,0179),
(1913,1139),
(1931,1139),
(1933,1339),
(1949,1499),
(1951,1159),
(1973,1379),
(1979,1799),
(1987,1789),
(1993,1399),
(1997,1799),
(1999,1999),
(2003,0023),
(2011,0112),
(2017,0127),
(2027,0227),
(2029,0229),
(2039,0239),
(2053,0235),
(2063,0236),
(2069,0269),
(2081,0128),
(2083,0238),
(2087,0278),
(2089,0289),
(2099,0299),
(2111,1112),
(2113,1123),
(2129,1229),
(2131,1123),
(2137,1237),
(2141,1124),
(2143,1234),
(2153,1235),
(2161,1126),
(2179,1279),
(2203,0223),
(2207,0227),
(2213,1223),
(2221,1222),
(2237,2237),
(2239,2239),
(2243,2234),
(2251,1225),
(2267,2267),
(2269,2269),
(2273,2237),
(2281,1228),
(2287,2278),
(2293,2239),
(2297,2279),
(2309,0239),
(2311,1123),
(2333,2333),
(2339,2339),
(2341,1234),
(2347,2347),
(2351,1235),
(2357,2357),
(2371,1237),
(2377,2377),
(2381,1238),
(2383,2338),
(2389,2389),
(2393,2339),
(2399,2399),
(2411,1124),
(2417,1247),
(2423,2234),
(2437,2347),
(2441,1244),
(2447,2447),
(2459,2459),
(2467,2467),
(2473,2347),
(2477,2477),
(2503,0235),
(2521,1225),
(2531,1235),
(2539,2359),
(2543,2345),
(2549,2459),
(2551,1255),
(2557,2557),
(2579,2579),
(2591,1259),
(2593,2359),
(2609,0269),
(2617,1267),
(2621,1226),
(2633,2336),
(2647,2467),
(2657,2567),
(2659,2569),
(2663,2366),
(2671,1267),
(2677,2677),
(2683,2368),
(2687,2678),
(2689,2689),
(2693,2369),
(2699,2699),
(2707,0277),
(2711,1127),
(2713,1237),
(2719,1279),
(2729,2279),
(2731,1237),
(2741,1247),
(2749,2479),
(2753,2357),
(2767,2677),
(2777,2777),
(2789,2789),
(2791,1279),
(2797,2779),
(2801,0128),
(2803,0238),
(2819,1289),
(2833,2338),
(2837,2378),
(2843,2348),
(2851,1258),
(2857,2578),
(2861,1268),
(2879,2789),
(2887,2788),
(2897,2789),
(2903,0239),
(2909,0299),
(2917,1279),
(2927,2279),
(2939,2399),
(2953,2359),
(2957,2579),
(2963,2369),
(2969,2699),
(2971,1279),
(2999,2999),
(3001,0013),
(3011,0113),
(3019,0139),
(3023,0233),
(3037,0337),
(3041,0134),
(3049,0349),
(3061,0136),
(3067,0367),
(3079,0379),
(3083,0338),
(3089,0389),
(3109,0139),
(3119,1139),
(3121,1123),
(3137,1337),
(3163,1336),
(3167,1367),
(3169,1369),
(3181,1138),
(3187,1378),
(3191,1139),
(3203,0233),
(3209,0239),
(3217,1237),
(3221,1223),
(3229,2239),
(3251,1235),
(3253,2335),
(3257,2357),
(3259,2359),
(3271,1237),
(3299,2399),
(3301,0133),
(3307,0337),
(3313,1333),
(3319,1339),
(3323,2333),
(3329,2339),
(3331,1333),
(3343,3334),
(3347,3347),
(3359,3359),
(3361,1336),
(3371,1337),
(3373,3337),
(3389,3389),
(3391,1339),
(3407,0347),
(3413,1334),
(3433,3334),
(3449,3449),
(3457,3457),
(3461,1346),
(3463,3346),
(3467,3467),
(3469,3469),
(3491,1349),
(3499,3499),
(3511,1135),
(3517,1357),
(3527,2357),
(3529,2359),
(3533,3335),
(3539,3359),
(3541,1345),
(3547,3457),
(3557,3557),
(3559,3559),
(3571,1357),
(3581,1358),
(3583,3358),
(3593,3359),
(3607,0367),
(3613,1336),
(3617,1367),
(3623,2336),
(3631,1336),
(3637,3367),
(3643,3346),
(3659,3569),
(3671,1367),
(3673,3367),
(3677,3677),
(3691,1369),
(3697,3679),
(3701,0137),
(3709,0379),
(3719,1379),
(3727,2377),
(3733,3337),
(3739,3379),
(3761,1367),
(3767,3677),
(3769,3679),
(3779,3779),
(3793,3379),
(3797,3779),
(3803,0338),
(3821,1238),
(3823,2338),
(3833,3338),
(3847,3478),
(3851,1358),
(3853,3358),
(3863,3368),
(3877,3778),
(3881,1388),
(3889,3889),
(3907,0379),
(3911,1139),
(3917,1379),
(3919,1399),
(3923,2339),
(3929,2399),
(3931,1339),
(3943,3349),
(3947,3479),
(3967,3679),
(3989,3899),
(4001,0014),
(4003,0034),
(4007,0047),
(4013,0134),
(4019,0149),
(4021,0124),
(4027,0247),
(4049,0449),
(4051,0145),
(4057,0457),
(4073,0347),
(4079,0479),
(4091,0149),
(4093,0349),
(4099,0499),
(4111,1114),
(4127,1247),
(4129,1249),
(4133,1334),
(4139,1349),
(4153,1345),
(4157,1457),
(4159,1459),
(4177,1477),
(4201,0124),
(4211,1124),
(4217,1247),
(4219,1249),
(4229,2249),
(4231,1234),
(4241,1244),
(4243,2344),
(4253,2345),
(4259,2459),
(4261,1246),
(4271,1247),
(4273,2347),
(4283,2348),
(4289,2489),
(4297,2479),
(4327,2347),
(4337,3347),
(4339,3349),
(4349,3449),
(4357,3457),
(4363,3346),
(4373,3347),
(4391,1349),
(4397,3479),
(4409,0449),
(4421,1244),
(4423,2344),
(4441,1444),
(4447,4447),
(4451,1445),
(4457,4457),
(4463,3446),
(4481,1448),
(4483,3448),
(4493,3449),
(4507,0457),
(4513,1345),
(4517,1457),
(4519,1459),
(4523,2345),
(4547,4457),
(4549,4459),
(4561,1456),
(4567,4567),
(4583,3458),
(4591,1459),
(4597,4579),
(4603,0346),
(4621,1246),
(4637,3467),
(4639,3469),
(4643,3446),
(4649,4469),
(4651,1456),
(4657,4567),
(4663,3466),
(4673,3467),
(4679,4679),
(4691,1469),
(4703,0347),
(4721,1247),
(4723,2347),
(4729,2479),
(4733,3347),
(4751,1457),
(4759,4579),
(4783,3478),
(4787,4778),
(4789,4789),
(4793,3479),
(4799,4799),
(4801,0148),
(4813,1348),
(4817,1478),
(4831,1348),
(4861,1468),
(4871,1478),
(4877,4778),
(4889,4889),
(4903,0349),
(4909,0499),
(4919,1499),
(4931,1349),
(4933,3349),
(4937,3479),
(4943,3449),
(4951,1459),
(4957,4579),
(4967,4679),
(4969,4699),
(4973,3479),
(4987,4789),
(4993,3499),
(4999,4999),
(5003,0035),
(5009,0059),
(5011,0115),
(5021,0125),
(5023,0235),
(5039,0359),
(5051,0155),
(5059,0559),
(5077,0577),
(5081,0158),
(5087,0578),
(5099,0599),
(5101,0115),
(5107,0157),
(5113,1135),
(5119,1159),
(5147,1457),
(5153,1355),
(5167,1567),
(5171,1157),
(5179,1579),
(5189,1589),
(5197,1579),
(5209,0259),
(5227,2257),
(5231,1235),
(5233,2335),
(5237,2357),
(5261,1256),
(5273,2357),
(5279,2579),
(5281,1258),
(5297,2579),
(5303,0335),
(5309,0359),
(5323,2335),
(5333,3335),
(5347,3457),
(5351,1355),
(5381,1358),
(5387,3578),
(5393,3359),
(5399,3599),
(5407,0457),
(5413,1345),
(5417,1457),
(5419,1459),
(5431,1345),
(5437,3457),
(5441,1445),
(5443,3445),
(5449,4459),
(5471,1457),
(5477,4577),
(5479,4579),
(5483,3458),
(5501,0155),
(5503,0355),
(5507,0557),
(5519,1559),
(5521,1255),
(5527,2557),
(5531,1355),
(5557,5557),
(5563,3556),
(5569,5569),
(5573,3557),
(5581,1558),
(5591,1559),
(5623,2356),
(5639,3569),
(5641,1456),
(5647,4567),
(5651,1556),
(5653,3556),
(5657,5567),
(5659,5569),
(5669,5669),
(5683,3568),
(5689,5689),
(5693,3569),
(5701,0157),
(5711,1157),
(5717,1577),
(5737,3577),
(5741,1457),
(5743,3457),
(5749,4579),
(5779,5779),
(5783,3578),
(5791,1579),
(5801,0158),
(5807,0578),
(5813,1358),
(5821,1258),
(5827,2578),
(5839,3589),
(5843,3458),
(5849,4589),
(5851,1558),
(5857,5578),
(5861,1568),
(5867,5678),
(5869,5689),
(5879,5789),
(5881,1588),
(5897,5789),
(5903,0359),
(5923,2359),
(5927,2579),
(5939,3599),
(5953,3559),
(5981,1589),
(5987,5789),
(6007,0067),
(6011,0116),
(6029,0269),
(6037,0367),
(6043,0346),
(6047,0467),
(6053,0356),
(6067,0667),
(6073,0367),
(6079,0679),
(6089,0689),
(6091,0169),
(6101,0116),
(6113,1136),
(6121,1126),
(6131,1136),
(6133,1336),
(6143,1346),
(6151,1156),
(6163,1366),
(6173,1367),
(6197,1679),
(6199,1699),
(6203,0236),
(6211,1126),
(6217,1267),
(6221,1226),
(6229,2269),
(6247,2467),
(6257,2567),
(6263,2366),
(6269,2669),
(6271,1267),
(6277,2677),
(6287,2678),
(6299,2699),
(6301,0136),
(6311,1136),
(6317,1367),
(6323,2336),
(6329,2369),
(6337,3367),
(6343,3346),
(6353,3356),
(6359,3569),
(6361,1366),
(6367,3667),
(6373,3367),
(6379,3679),
(6389,3689),
(6397,3679),
(6421,1246),
(6427,2467),
(6449,4469),
(6451,1456),
(6469,4669),
(6473,3467),
(6481,1468),
(6491,1469),
(6521,1256),
(6529,2569),
(6547,4567),
(6551,1556),
(6553,3556),
(6563,3566),
(6569,5669),
(6571,1567),
(6577,5677),
(6581,1568),
(6599,5699),
(6607,0667),
(6619,1669),
(6637,3667),
(6653,3566),
(6659,5669),
(6661,1666),
(6673,3667),
(6679,6679),
(6689,6689),
(6691,1669),
(6701,0167),
(6703,0367),
(6709,0679),
(6719,1679),
(6733,3367),
(6737,3677),
(6761,1667),
(6763,3667),
(6779,6779),
(6781,1678),
(6791,1679),
(6793,3679),
(6803,0368),
(6823,2368),
(6827,2678),
(6829,2689),
(6833,3368),
(6841,1468),
(6857,5678),
(6863,3668),
(6869,6689),
(6871,1678),
(6883,3688),
(6899,6899),
(6907,0679),
(6911,1169),
(6917,1679),
(6947,4679),
(6949,4699),
(6959,5699),
(6961,1669),
(6967,6679),
(6971,1679),
(6977,6779),
(6983,3689),
(6991,1699),
(6997,6799),
(7001,0017),
(7013,0137),
(7019,0179),
(7027,0277),
(7039,0379),
(7043,0347),
(7057,0577),
(7069,0679),
(7079,0779),
(7103,0137),
(7109,0179),
(7121,1127),
(7127,1277),
(7129,1279),
(7151,1157),
(7159,1579),
(7177,1777),
(7187,1778),
(7193,1379),
(7207,0277),
(7211,1127),
(7213,1237),
(7219,1279),
(7229,2279),
(7237,2377),
(7243,2347),
(7247,2477),
(7253,2357),
(7283,2378),
(7297,2779),
(7307,0377),
(7309,0379),
(7321,1237),
(7331,1337),
(7333,3337),
(7349,3479),
(7351,1357),
(7369,3679),
(7393,3379),
(7411,1147),
(7417,1477),
(7433,3347),
(7451,1457),
(7457,4577),
(7459,4579),
(7477,4777),
(7481,1478),
(7487,4778),
(7489,4789),
(7499,4799),
(7507,0577),
(7517,1577),
(7523,2357),
(7529,2579),
(7537,3577),
(7541,1457),
(7547,4577),
(7549,4579),
(7559,5579),
(7561,1567),
(7573,3577),
(7577,5777),
(7583,3578),
(7589,5789),
(7591,1579),
(7603,0367),
(7607,0677),
(7621,1267),
(7639,3679),
(7643,3467),
(7649,4679),
(7669,6679),
(7673,3677),
(7681,1678),
(7687,6778),
(7691,1679),
(7699,6799),
(7703,0377),
(7717,1777),
(7723,2377),
(7727,2777),
(7741,1477),
(7753,3577),
(7757,5777),
(7759,5779),
(7789,7789),
(7793,3779),
(7817,1778),
(7823,2378),
(7829,2789),
(7841,1478),
(7853,3578),
(7867,6778),
(7873,3778),
(7877,7778),
(7879,7789),
(7883,3788),
(7901,0179),
(7907,0779),
(7919,1799),
(7927,2779),
(7933,3379),
(7937,3779),
(7949,4799),
(7951,1579),
(7963,3679),
(7993,3799),
(8009,0089),
(8011,0118),
(8017,0178),
(8039,0389),
(8053,0358),
(8059,0589),
(8069,0689),
(8081,0188),
(8087,0788),
(8089,0889),
(8093,0389),
(8101,0118),
(8111,1118),
(8117,1178),
(8123,1238),
(8147,1478),
(8161,1168),
(8167,1678),
(8171,1178),
(8179,1789),
(8191,1189),
(8209,0289),
(8219,1289),
(8221,1228),
(8231,1238),
(8233,2338),
(8237,2378),
(8243,2348),
(8263,2368),
(8269,2689),
(8273,2378),
(8287,2788),
(8291,1289),
(8293,2389),
(8297,2789),
(8311,1138),
(8317,1378),
(8329,2389),
(8353,3358),
(8363,3368),
(8369,3689),
(8377,3778),
(8387,3788),
(8389,3889),
(8419,1489),
(8423,2348),
(8429,2489),
(8431,1348),
(8443,3448),
(8447,4478),
(8461,1468),
(8467,4678),
(8501,0158),
(8513,1358),
(8521,1258),
(8527,2578),
(8537,3578),
(8539,3589),
(8543,3458),
(8563,3568),
(8573,3578),
(8581,1588),
(8597,5789),
(8599,5899),
(8609,0689),
(8623,2368),
(8627,2678),
(8629,2689),
(8641,1468),
(8647,4678),
(8663,3668),
(8669,6689),
(8677,6778),
(8681,1688),
(8689,6889),
(8693,3689),
(8699,6899),
(8707,0778),
(8713,1378),
(8719,1789),
(8731,1378),
(8737,3778),
(8741,1478),
(8747,4778),
(8753,3578),
(8761,1678),
(8779,7789),
(8783,3788),
(8803,0388),
(8807,0788),
(8819,1889),
(8821,1288),
(8831,1388),
(8837,3788),
(8839,3889),
(8849,4889),
(8861,1688),
(8863,3688),
(8867,6788),
(8887,7888),
(8893,3889),
(8923,2389),
(8929,2899),
(8933,3389),
(8941,1489),
(8951,1589),
(8963,3689),
(8969,6899),
(8971,1789),
(8999,8999),
(9001,0019),
(9007,0079),
(9011,0119),
(9013,0139),
(9029,0299),
(9041,0149),
(9043,0349),
(9049,0499),
(9059,0599),
(9067,0679),
(9091,0199),
(9103,0139),
(9109,0199),
(9127,1279),
(9133,1339),
(9137,1379),
(9151,1159),
(9157,1579),
(9161,1169),
(9173,1379),
(9181,1189),
(9187,1789),
(9199,1999),
(9203,0239),
(9209,0299),
(9221,1229),
(9227,2279),
(9239,2399),
(9241,1249),
(9257,2579),
(9277,2779),
(9281,1289),
(9283,2389),
(9293,2399),
(9311,1139),
(9319,1399),
(9323,2339),
(9337,3379),
(9341,1349),
(9343,3349),
(9349,3499),
(9371,1379),
(9377,3779),
(9391,1399),
(9397,3799),
(9403,0349),
(9413,1349),
(9419,1499),
(9421,1249),
(9431,1349),
(9433,3349),
(9437,3479),
(9439,3499),
(9461,1469),
(9463,3469),
(9467,4679),
(9473,3479),
(9479,4799),
(9491,1499),
(9497,4799),
(9511,1159),
(9521,1259),
(9533,3359),
(9539,3599),
(9547,4579),
(9551,1559),
(9587,5789),
(9601,0169),
(9613,1369),
(9619,1699),
(9623,2369),
(9629,2699),
(9631,1369),
(9643,3469),
(9649,4699),
(9661,1669),
(9677,6779),
(9679,6799),
(9689,6899),
(9697,6799),
(9719,1799),
(9721,1279),
(9733,3379),
(9739,3799),
(9743,3479),
(9749,4799),
(9767,6779),
(9769,6799),
(9781,1789),
(9787,7789),
(9791,1799),
(9803,0389),
(9811,1189),
(9817,1789),
(9829,2899),
(9833,3389),
(9839,3899),
(9851,1589),
(9857,5789),
(9859,5899),
(9871,1789),
(9883,3889),
(9887,7889),
(9901,0199),
(9907,0799),
(9923,2399),
(9929,2999),
(9931,1399),
(9941,1499),
(9949,4999),
(9967,6799),
(9973,3799);