← 返回题库
初级

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 "Credit amount" FROM german_credit_risk ORDER BY "Credit amount" DESC').fetchall()
    conn.close()
    return result

示例

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

登录后即可练习

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

登录 免费注册