← 返回题库
初级

SELECT基础：查询指定列

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
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" FROM german_credit_risk').fetchall()
    conn.close()
    return result

示例

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

登录后即可练习

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

登录 免费注册