初级

ORDER BY：按列位置排序

未完成

初级参考完整示例代码供参考，建议自己理解后重新输入

def solve():
    import sqlite3
    import pandas as pd
    conn = sqlite3.connect(':memory:')
    df = pd.read_csv('https://liangdaima.com/static/data/german_credit_risk.csv')
    df.to_sql('german_credit_risk', conn, index=False)
    result = conn.execute('SELECT Age, "Credit amount", Duration FROM german_credit_risk ORDER BY 2 DESC').fetchall()
    conn.close()
    return result

示例

输入

print(solve())

期望输出

[(32, 18424, 48), (58, 15945, 54), (43, 15857, 36), (23, 15672, 48), (21, 15653, 60), (68, 14896, 6), (60, 14782, 60), (23, 14555, 6), (25, 14421, 48), (57, 14318, 36), (30, 14179, 39), (27, 14027, 60), (63, 13756, 60), (38, 12976, 18), (37, 12749, 48), (30, 12680, 21), (47, 12612, 36), (44, 12579, 24), (37, 12389, 36), (48, 12204, 48), (36, 12169, 48), (34, 11998, 30), (39, 11938, 24), (29, 11816, 45), (32, 11760, 39), (24, 11590, 48), (23, 11560, 24), (29, 11328, 24), (30, 11054, 36), (26, 10974, 36), (27, 10961, 48), (45, 10875, 36), (35, 10722, 47), (38, 10623, 30), (42, 10477, 36), (42, 10366, 60), (39, 10297, 48), (37, 10222, 48), (21, 10144, 60), (44, 10127, 48), (26, 9960, 48), (31, 9857, 36), (24, 9629, 36), (28, 9572, 36), (31, 9566, 36), (39, 9436, 54), (28, 9398, 36), (55, 9283, 42), (48, 9277, 24), (24, 9271, 36), (27, 9157, 60), (35, 9055, 36), (29, 9034, 36), (45, 8978, 14), (31, 8947, 36), (35, 8858, 48), (27, 8648, 24), (27, 8613, 27), (45, 8588, 39), (24, 8487, 48), (23, 8471, 18), (49, 8386, 30), (30, 8358, 48), (47, 8335, 36), (42, 8318, 27), (26, 8229, 36), (30, 8133, 36), (42, 8086, 36), (25, 8072, 30), (25, 8065, 36), (27, 7980, 36), (30, 7966, 26), (45, 7882, 42), (53, 7865, 12), (25, 7855, 36), (40, 7824, 28), (38, 7814, 24), (42, 7763, 48), (29, 7758, 24), (30, 7721, 24), (37, 7685, 48), (40, 7678, 36), (46, 7629, 48), (63, 7596, 30), (31, 7582, 48), (51, 7511, 18), (53, 7485, 30), (50, 7476, 48), (24, 7472, 12), (54, 7432, 36), (27, 7418, 60), (37, 7409, 36), (24, 7408, 60), (43, 7393, 24), (40, 7374, 18), (70, 7308, 10), (36, 7297, 60), (35, 7253, 33), (32, 7238, 48), (39, 7228, 11), (30, 7174, 42), (29, 7166, 42), (23, 7127, 36), (53, 7119, 48), (36, 7057, 20), (34, 6999, 48), (36, 6967, 24), (35, 6948, 36), (29, 6887, 36), (55, 6872, 24), (34, 6850, 15), (46, 6842, 24), (63, 6836, 60), (45, 6761, 6), (68, 6761, 18), (31, 6758, 48), (36, 6742, 30), (38, 6681, 48), (75, 6615, 24), (34, 6614, 36), (29, 6579, 24), (21, 6568, 24), (24, 6560, 48), (34, 6527, 60), (52, 6468, 12), (60, 6468, 20), (39, 6458, 18), (44, 6419, 24), (59, 6416, 48), (33, 6403, 24), (41, 6361, 18), (31, 6350, 30), (46, 6331, 48), (27, 6314, 24), (41, 6313, 24), (36, 6304, 36), (33, 6289, 42), (42, 6288, 60), (28, 6260, 18), (23, 6229, 36), (50, 6224, 48), (44, 6204, 18), (28, 6199, 12), (24, 6187, 30), (31, 6148, 20), (58, 6143, 48), (31, 6110, 48), (32, 6078, 12), (33, 6070, 18), (27, 5998, 40), (30, 5965, 27), (41, 5954, 42), (38, 5954, 30), (22, 5951, 48), (44, 5943, 24), (30, 5866, 18), (24, 5848, 36), (35, 5842, 36), (27, 5804, 24), (49, 5801, 12), (34, 5800, 36), (25, 5771, 30), (24, 5743, 24), (31, 5742, 36), (38, 5711, 36), (24, 5595, 72), (25, 5511, 24), (44, 5507, 24), (42, 5493, 36), (26, 5433, 24), (40, 5381, 48), (28, 5371, 36), (35, 5324, 15), (36, 5302, 18), (50, 5293, 27), (26, 5248, 21), (28, 5234, 30), (48, 5190, 27), (29, 5179, 36), (25, 5152, 24), (33, 5150, 24), (74, 5129, 9), (26, 5117, 27), (47, 5103, 24), (30, 5096, 48), (42, 5084, 24), (59, 5045, 15), (29, 5003, 21), (25, 4933, 39), (53, 4870, 24), (33, 4844, 48), (43, 4843, 12), (31, 4817, 24), (24, 4811, 30), (56, 4796, 42), (30, 4795, 36), (26, 4788, 48), (51, 4771, 11), (25, 4746, 45), (25, 4736, 24), (44, 4716, 6), (37, 4712, 24), (32, 4686, 36), (35, 4679, 24), (20, 4675, 12), (30, 4657, 15), (40, 4623, 15), (32, 4611, 6), (24, 4605, 48), (32, 4594, 18), (54, 4591, 24), (32, 4583, 30), (27, 4576, 45), (26, 4530, 30), (74, 4526, 24), (32, 4526, 27), (31, 4473, 36), (26, 4463, 36), (30, 4455, 36), (34, 4454, 36), (33, 4439, 18), (35, 4380, 18), (26, 4370, 42), (48, 4351, 24), (24, 4308, 48), (40, 4297, 18), (23, 4281, 33), (26, 4280, 30), (26, 4272, 30), (24, 4272, 20), (28, 4249, 30), (36, 4241, 24), (28, 4221, 30), (26, 4210, 36), (28, 4169, 24), (36, 4165, 18), (42, 4153, 18), (35, 4151, 24), (27, 4139, 24), (28, 4113, 24), (23, 4110, 24), (43, 4057, 24), (36, 4042, 42), (43, 4042, 24), (27, 4020, 24), (45, 4006, 28), (29, 3990, 36), (41, 3979, 48), (35, 3976, 21), (22, 3973, 14), (25, 3972, 24), (33, 3966, 18), (34, 3965, 42), (29, 3959, 15), (30, 3959, 36), (37, 3949, 10), (40, 3939, 11), (46, 3931, 48), (36, 3915, 27), (38, 3914, 48), (23, 3913, 36), (36, 3905, 11), (37, 3878, 24), (67, 3872, 18), (41, 3868, 24), (32, 3863, 24), (40, 3857, 30), (27, 3850, 18), (34, 3844, 48), (45, 3835, 36), (22, 3832, 30), (64, 3832, 9), (23, 3812, 15), (42, 3804, 36), (35, 3780, 18), (50, 3777, 24), (24, 3763, 21), (23, 3758, 24), (62, 3757, 24), (26, 3749, 24), (27, 3711, 36), (37, 3676, 6), (28, 3660, 24), (49, 3656, 30), (27, 3652, 21), (31, 3651, 12), (22, 3650, 18), (27, 3643, 15), (22, 3632, 24), (57, 3622, 30), (31, 3621, 24), (37, 3620, 36), (20, 3617, 24), (28, 3617, 12), (37, 3612, 18), (27, 3609, 48), (26, 3599, 21), (28, 3595, 36), (46, 3594, 15), (29, 3590, 12), (40, 3590, 18), (47, 3578, 48), (26, 3577, 9), (23, 3573, 12), (54, 3568, 15), (30, 3566, 48), (37, 3565, 12), (29, 3556, 15), (27, 3552, 24), (37, 3535, 36), (45, 3527, 12), (26, 3518, 6), (38, 3512, 24), (25, 3509, 18), (29, 3499, 12), (34, 3496, 30), (23, 3488, 24), (44, 3485, 20), (74, 3448, 5), (35, 3447, 12), (42, 3446, 36), (21, 3441, 30), (31, 3430, 24), (47, 3422, 18), (27, 3416, 27), (26, 3414, 21), (37, 3399, 12), (39, 3398, 8), (65, 3394, 42), (35, 3386, 12), (44, 3384, 6), (37, 3380, 4), (31, 3378, 18), (23, 3368, 15), (29, 3357, 21), (28, 3349, 36), (30, 3349, 24), (39, 3345, 24), (28, 3343, 15), (51, 3342, 36), (42, 3331, 12), (36, 3275, 21), (39, 3249, 36), (33, 3244, 18), (26, 3235, 24), (23, 3234, 24), (38, 3229, 18), (25, 3213, 18), (33, 3195, 9), (24, 3190, 18), (20, 3186, 15), (26, 3181, 24), (31, 3161, 24), (41, 3160, 21), (22, 3149, 24), (31, 3148, 24), (49, 3124, 12), (27, 3123, 24), (26, 3114, 18), (31, 3108, 30), (25, 3105, 24), (31, 3104, 18), (22, 3092, 24), (36, 3079, 36), (52, 3077, 12), (40, 3077, 30), (33, 3074, 9), (30, 3069, 24), (32, 3062, 24), (28, 3060, 48), (61, 3059, 12), (54, 3051, 48), (45, 3049, 18), (21, 3031, 45), (33, 3029, 15), (24, 3021, 24), (34, 3017, 12), (47, 3017, 30), (24, 3016, 12), (40, 3001, 18), (20, 2996, 24), (28, 2993, 21), (25, 2991, 30), (32, 2978, 6), (32, 2978, 24), (25, 2969, 12), (49, 2964, 24), (63, 2957, 24), (27, 2930, 12), (63, 2924, 24), (28, 2923, 21), (34, 2910, 24), (31, 2901, 10), (43, 2899, 18), (29, 2896, 24), (51, 2892, 24), (36, 2872, 24), (34, 2864, 18), (30, 2862, 36), (38, 2859, 12), (32, 2848, 10), (53, 2835, 24), (33, 2831, 30), (22, 2828, 24), (34, 2825, 24), (27, 2820, 36), (26, 2812, 24), (36, 2799, 9), (24, 2788, 15), (31, 2782, 21), (21, 2779, 18), (31, 2775, 18), (61, 2767, 21), (26, 2764, 33), (25, 2762, 12), (36, 2760, 24), (34, 2759, 12), (35, 2753, 9), (38, 2751, 48), (57, 2748, 12), (31, 2746, 36), (32, 2745, 21), (29, 2743, 28), (35, 2728, 15), (20, 2718, 24), (41, 2712, 36), (27, 2708, 15), (32, 2697, 9), (26, 2687, 15), (35, 2684, 24), (29, 2679, 24), (40, 2675, 22), (50, 2671, 36), (35, 2670, 24), (32, 2662, 18), (28, 2659, 18), (44, 2647, 6), (28, 2631, 15), (25, 2631, 15), (29, 2629, 20), (43, 2625, 16), (34, 2622, 18), (27, 2613, 36), (46, 2611, 24), (28, 2606, 21), (28, 2603, 24), (65, 2600, 18), (41, 2580, 21), (33, 2579, 12), (55, 2578, 12), (34, 2578, 24), (42, 2577, 12), (35, 2576, 7), (21, 2570, 27), (24, 2569, 39), (47, 2538, 24), (32, 2528, 27), (39, 2522, 30), (23, 2520, 27), (43, 2515, 18), (23, 2511, 15), (51, 2507, 9), (41, 2503, 30), (22, 2483, 24), (46, 2476, 21), (25, 2473, 18), (27, 2463, 24), (22, 2462, 18), (26, 2445, 12), (43, 2442, 27), (35, 2439, 24), (42, 2427, 18), (53, 2424, 24), (34, 2415, 7), (23, 2406, 30), (31, 2406, 9), (26, 2404, 18), (35, 2397, 24), (25, 2394, 36), (50, 2390, 12), (27, 2389, 18), (33, 2384, 36), (64, 2384, 24), (44, 2375, 24), (36, 2366, 12), (36, 2360, 15), (33, 2359, 24), (47, 2353, 21), (46, 2348, 36), (35, 2346, 24), (36, 2337, 36), (30, 2333, 30), (29, 2333, 24), (49, 2331, 12), (45, 2329, 7), (25, 2327, 15), (27, 2326, 15), (32, 2325, 24), (24, 2323, 36), (34, 2320, 18), (33, 2319, 21), (52, 2315, 10), (45, 2303, 24), (31, 2302, 36), (22, 2301, 9), (39, 2299, 36), (42, 2292, 12), (23, 2288, 21), (28, 2284, 24), (37, 2279, 12), (28, 2278, 18), (32, 2273, 36), (54, 2255, 24), (46, 2251, 12), (30, 2249, 18), (36, 2247, 12), (60, 2246, 12), (48, 2241, 10), (50, 2241, 21), (25, 2238, 18), (33, 2235, 20), (57, 2225, 36), (52, 2223, 24), (20, 2221, 15), (24, 2214, 12), (39, 2212, 20), (25, 2210, 10), (43, 2197, 24), (33, 2186, 15), (36, 2181, 30), (29, 2171, 12), (38, 2171, 12), (28, 2169, 18), (24, 2150, 30), (29, 2149, 12), (23, 2146, 10), (24, 2145, 36), (28, 2142, 11), (35, 2141, 12), (25, 2136, 9), (48, 2134, 9), (52, 2133, 12), (27, 2132, 10), (24, 2124, 18), (39, 2122, 12), (30, 2121, 12), (37, 2118, 9), (41, 2116, 6), (29, 2108, 6), (23, 2101, 13), (37, 2100, 18), (49, 2096, 12), (24, 2080, 6), (28, 2073, 12), (26, 2069, 10), (34, 2064, 24), (30, 2063, 6), (33, 2058, 24), (33, 2051, 18), (22, 2039, 24), (20, 2039, 18), (60, 2032, 24), (24, 2030, 9), (30, 2028, 12), (30, 2028, 24), (37, 2022, 24), (61, 2012, 12), (30, 2002, 12), (27, 1995, 12), (21, 1987, 24), (47, 1984, 18), (19, 1980, 9), (35, 1979, 15), (40, 1977, 36), (20, 1967, 24), (42, 1965, 24), (31, 1963, 12), (23, 1961, 18), (31, 1957, 6), (61, 1953, 36), (34, 1950, 18), (23, 1943, 18), (35, 1941, 18), (60, 1940, 24), (36, 1940, 18), (32, 1938, 24), (23, 1936, 18), (31, 1935, 24), (43, 1935, 12), (26, 1934, 12), (31, 1928, 18), (33, 1927, 24), (26, 1925, 24), (27, 1924, 18), (38, 1924, 10), (37, 1922, 12), (35, 1919, 9), (30, 1919, 30), (36, 1913, 18), (66, 1908, 30), (40, 1905, 15), (29, 1901, 24), (34, 1898, 6), (29, 1893, 12), (28, 1887, 18), (39, 1884, 12), (25, 1882, 18), (44, 1881, 12), (32, 1880, 18), (36, 1872, 6), (58, 1867, 30), (30, 1864, 18), (34, 1860, 12), (22, 1858, 12), (33, 1851, 24), (46, 1845, 15), (23, 1845, 45), (34, 1842, 36), (34, 1837, 24), (25, 1835, 21), (46, 1829, 15), (30, 1823, 24), (30, 1820, 18), (37, 1819, 36), (28, 1817, 18), (22, 1808, 18), (44, 1804, 12), (24, 1800, 18), (28, 1797, 13), (48, 1795, 18), (26, 1778, 15), (24, 1768, 12), (21, 1766, 6), (58, 1755, 24), (45, 1750, 6), (24, 1747, 24), (34, 1743, 6), (48, 1743, 24), (30, 1740, 6), (31, 1736, 12), (36, 1721, 15), (26, 1715, 30), (35, 1680, 12), (22, 1670, 9), (29, 1659, 24), (27, 1657, 12), (63, 1655, 12), (40, 1647, 21), (30, 1620, 12), (55, 1603, 24), (30, 1602, 21), (40, 1597, 10), (54, 1597, 24), (51, 1595, 6), (35, 1592, 12), (34, 1591, 21), (40, 1585, 24), (46, 1582, 18), (20, 1577, 11), (50, 1574, 12), (36, 1572, 21), (34, 1569, 15), (24, 1568, 18), (22, 1567, 12), (50, 1559, 24), (55, 1555, 12), (24, 1554, 6), (23, 1553, 24), (44, 1553, 18), (32, 1552, 24), (35, 1549, 9), (24, 1546, 24), (31, 1546, 10), (42, 1544, 4), (33, 1543, 6), (36, 1542, 12), (56, 1538, 6), (50, 1537, 15), (23, 1534, 12), (38, 1533, 24), (43, 1533, 18), (31, 1532, 15), (32, 1530, 18), (66, 1526, 12), (34, 1525, 24), (31, 1521, 10), (63, 1520, 15), (43, 1516, 24), (22, 1514, 15), (61, 1512, 15), (32, 1505, 18), (42, 1503, 4), (41, 1503, 12), (34, 1501, 9), (23, 1498, 12), (38, 1495, 12), (29, 1494, 4), (34, 1493, 12), (25, 1484, 12), (66, 1480, 12), (22, 1478, 9), (44, 1478, 15), (33, 1478, 15), (33, 1474, 12), (33, 1474, 24), (39, 1473, 18), (35, 1471, 15), (41, 1469, 24), (43, 1459, 15), (42, 1455, 4), (26, 1453, 18), (31, 1449, 6), (27, 1449, 9), (49, 1445, 18), (23, 1444, 15), (23, 1442, 24), (32, 1442, 18), (29, 1437, 9), (25, 1433, 15), (26, 1424, 12), (55, 1424, 12), (27, 1422, 9), (35, 1418, 10), (33, 1414, 8), (55, 1413, 12), (28, 1413, 24), (29, 1412, 12), (35, 1410, 14), (31, 1410, 12), (54, 1409, 12), (64, 1409, 13), (28, 1403, 15), (37, 1402, 12), (35, 1393, 11), (47, 1393, 12), (31, 1393, 24), (27, 1391, 9), (26, 1388, 9), (26, 1386, 12), (40, 1386, 15), (28, 1382, 6), (26, 1382, 24), (35, 1381, 24), (47, 1377, 24), (28, 1376, 24), (36, 1374, 6), (75, 1374, 6), (36, 1372, 12), (25, 1371, 24), (22, 1366, 9), (64, 1364, 10), (59, 1364, 9), (40, 1361, 6), (31, 1360, 15), (40, 1358, 24), (25, 1355, 24), (23, 1352, 6), (27, 1347, 10), (42, 1346, 6), (26, 1345, 18), (37, 1344, 24), (43, 1344, 12), (46, 1343, 6), (62, 1338, 6), (34, 1337, 9), (43, 1333, 24), (22, 1331, 12), (26, 1330, 12), (28, 1323, 6), (40, 1322, 11), (54, 1318, 12), (47, 1316, 15), (20, 1313, 9), (26, 1311, 24), (27, 1309, 10), (38, 1308, 15), (32, 1301, 18), (45, 1300, 15), (74, 1299, 6), (23, 1297, 12), (25, 1295, 12), (27, 1295, 18), (35, 1291, 12), (21, 1289, 12), (48, 1288, 9), (45, 1287, 10), (37, 1287, 24), (32, 1285, 24), (25, 1283, 22), (32, 1282, 24), (20, 1282, 12), (36, 1278, 24), (24, 1275, 15), (23, 1275, 10), (36, 1275, 24), (37, 1274, 12), (39, 1271, 15), (57, 1264, 12), (25, 1264, 15), (25, 1262, 12), (36, 1262, 15), (49, 1262, 12), (25, 1258, 24), (22, 1258, 12), (57, 1258, 24), (61, 1255, 12), (28, 1249, 24), (23, 1246, 24), (33, 1245, 18), (41, 1244, 9), (38, 1240, 12), (48, 1240, 10), (61, 1239, 18), (36, 1238, 6), (24, 1237, 8), (27, 1237, 6), (23, 1236, 9), (50, 1236, 6), (32, 1231, 10), (57, 1231, 24), (24, 1228, 12), (37, 1225, 10), (30, 1224, 9), (46, 1223, 12), (27, 1221, 6), (47, 1217, 18), (38, 1216, 24), (23, 1216, 18), (47, 1213, 15), (47, 1209, 6), (24, 1207, 24), (25, 1206, 9), (35, 1204, 6), (43, 1203, 6), (26, 1201, 24), (23, 1200, 12), (60, 1199, 24), (67, 1199, 9), (35, 1198, 6), (29, 1193, 24), (55, 1190, 18), (39, 1188, 21), (27, 1185, 12), (68, 1175, 16), (67, 1169, 6), (29, 1169, 18), (27, 1168, 12), (51, 1164, 8), (44, 1163, 12), (26, 1158, 12), (40, 1155, 12), (57, 1154, 11), (37, 1154, 9), (46, 1149, 18), (25, 1138, 9), (32, 1136, 9), (33, 1131, 18), (21, 1126, 18), (49, 1126, 9), (29, 1123, 12), (26, 1113, 18), (28, 1108, 12), (20, 1107, 12), (29, 1103, 12), (27, 1101, 12), (65, 1098, 18), (49, 1092, 12), (27, 1082, 9), (48, 1082, 12), (26, 1076, 12), (28, 1068, 6), (30, 1056, 18), (30, 1055, 18), (27, 1053, 15), (35, 1050, 6), (21, 1049, 18), (23, 1048, 10), (50, 1047, 6), (33, 1042, 18), (49, 1038, 10), (39, 1037, 12), (36, 1028, 18), (48, 1024, 24), (22, 1007, 12), (25, 999, 24), (23, 996, 12), (19, 983, 12), (23, 976, 18), (35, 976, 12), (25, 975, 15), (30, 960, 15), (29, 959, 9), (47, 958, 12), (27, 951, 12), (33, 950, 15), (38, 947, 24), (28, 939, 12), (27, 937, 24), (52, 936, 9), (24, 932, 6), (39, 932, 6), (32, 931, 6), (65, 930, 12), (31, 929, 24), (38, 926, 12), (30, 918, 9), (29, 915, 24), (36, 909, 36), (26, 907, 8), (21, 902, 12), (23, 900, 12), (40, 894, 10), (41, 888, 12), (21, 886, 12), (36, 884, 18), (23, 882, 13), (24, 874, 15), (25, 866, 18), (39, 860, 6), (36, 846, 7), (23, 841, 12), (23, 836, 12), (22, 806, 15), (38, 804, 12), (37, 802, 15), (27, 802, 14), (33, 797, 12), (53, 795, 12), (66, 790, 9), (26, 783, 6), (63, 781, 10), (28, 776, 12), (66, 766, 12), (26, 763, 12), (44, 760, 8), (26, 759, 12), (38, 754, 12), (64, 753, 6), (27, 750, 18), (28, 745, 9), (22, 741, 12), (47, 731, 8), (46, 730, 7), (33, 727, 12), (46, 727, 10), (41, 719, 12), (52, 717, 12), (54, 717, 24), (27, 709, 6), (57, 709, 12), (38, 708, 12), (30, 707, 12), (40, 701, 12), (32, 701, 12), (36, 700, 6), (46, 697, 12), (35, 691, 12), (25, 685, 12), (40, 684, 12), (29, 683, 6), (51, 682, 12), (20, 674, 12), (54, 672, 6), (39, 666, 6), (41, 662, 6), (23, 660, 6), (28, 654, 9), (24, 652, 12), (49, 640, 12), (30, 639, 12), (32, 629, 18), (24, 626, 12), (26, 625, 12), (56, 618, 12), (26, 609, 12), (37, 609, 6), (23, 601, 4), (26, 590, 6), (20, 585, 12), (65, 571, 21), (42, 522, 12), (29, 518, 6), (28, 484, 6), (24, 458, 9), (22, 454, 6), (23, 448, 6), (22, 433, 18), (24, 433, 6), (49, 428, 6), (39, 426, 6), (42, 409, 12), (23, 392, 15), (58, 385, 12), (38, 368, 6), (52, 362, 6), (27, 343, 6), (45, 339, 12), (52, 338, 6), (22, 276, 9), (41, 250, 6)]

Python 代码 🔒 登录后使用

def solve():
    pass

🔒

登录后即可练习

注册免费账号，在浏览器中直接运行 Python 代码

登录免费注册

ORDER BY：按列位置排序

示例

登录后即可练习

升级 VIP

联系客服