SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE students ( id INT PRIMARY KEY, name VARCHAR(256) NOT NULL ); CREATE TABLE marks ( id INT PRIMARY KEY, student_id INT NOT NULL, val TINYINT NOT NULL ); INSERT INTO students (id, name) VALUES (1, 'Иван'), (2, 'Николай'), (3, 'Михаил'), (4, 'Владимир'), (5, 'Петр'), (6, 'Лидия'), (7, 'Анфиса'), (8, 'Артур'), (9, 'Сергей'), (10, 'Таня'), (11, 'Света'), (12, 'Григорий'), (13, 'Афанасий'), (14, 'Эльдар'), (15, 'John'), (16, 'Barbara'); INSERT INTO marks (id, student_id, val) VALUES (1047664, 1, 2), (1144182, 1, 3), (1240620, 1, 5), (1327360, 1, 3), (1455413, 1, 4), (1568310, 1, 2), (1638754, 1, 4), (1744197, 1, 4), (1821730, 1, 4), (1968147, 1, 2), (11048542, 1, 5), (11165908, 1, 4), (11238288, 1, 4), (11330691, 1, 4), (11487497, 1, 5), (11588456, 1, 5), (11617488, 1, 4), (11774106, 1, 4), (11827066, 1, 5), (11958765, 1, 5), (12052365, 1, 2), (12166409, 1, 2), (12228258, 1, 4), (12352038, 1, 4), (12422801, 1, 5), (12571519, 1, 4), (12698658, 1, 4), (12774823, 1, 2), (12875729, 1, 5), (12942127, 1, 3), (13038830, 1, 4), (13142425, 1, 3), (13295802, 1, 5), (13316247, 1, 4), (13479799, 1, 5), (13596373, 1, 4), (13698888, 1, 3), (13731747, 1, 3), (13816687, 1, 3), (13936575, 1, 2), (14071506, 1, 5), (14178336, 1, 4), (14290457, 1, 2), (14327076, 1, 5), (14494783, 1, 3), (14590642, 1, 5), (14660147, 1, 5), (14717563, 1, 4), (14822879, 1, 2), (14951498, 1, 5), (15017130, 1, 2), (2046508, 2, 4), (2188224, 2, 3), (2273142, 2, 2), (2373787, 2, 4), (2455440, 2, 3), (2529071, 2, 4), (2693384, 2, 4), (2786546, 2, 4), (2898384, 2, 5), (2923380, 2, 4), (21078689, 2, 5), (21135934, 2, 4), (21212154, 2, 3), (21377090, 2, 4), (21492020, 2, 5), (21592493, 2, 4), (21663059, 2, 3), (21761967, 2, 4), (21820926, 2, 3), (21991061, 2, 4), (22078300, 2, 4), (22118047, 2, 3), (22263636, 2, 4), (22362822, 2, 4), (22467835, 2, 3), (22557115, 2, 2), (22673772, 2, 4), (22740925, 2, 5), (22895834, 2, 5), (22978553, 2, 4), (23060500, 2, 3), (23111933, 2, 5), (23280493, 2, 5), (23366278, 2, 2), (23438809, 2, 4), (23527017, 2, 3), (23653049, 2, 5), (23734560, 2, 3), (23886562, 2, 3), (23913647, 2, 5), (24041891, 2, 2), (24133916, 2, 3), (24276812, 2, 4), (24382586, 2, 5), (24461368, 2, 2), (24599987, 2, 3), (24698210, 2, 2), (24739218, 2, 4), (24831191, 2, 5), (24997721, 2, 3), (25034275, 2, 5), (3071908, 3, 4), (3199771, 3, 4), (3293610, 3, 5), (3375711, 3, 5), (3449726, 3, 3), (3576458, 3, 4), (3641277, 3, 3), (3723369, 3, 4), (3836139, 3, 5), (3940143, 3, 3), (31020991, 3, 4), (31142270, 3, 4), (31252707, 3, 4), (31389459, 3, 2), (31416508, 3, 5), (31530656, 3, 3), (31651476, 3, 3), (31766591, 3, 5), (31820668, 3, 3), (31958424, 3, 3), (32012068, 3, 2), (32152546, 3, 5), (32251736, 3, 5), (32357156, 3, 5), (32448868, 3, 4), (32568735, 3, 3), (32639552, 3, 5), (32724043, 3, 4), (32862914, 3, 5), (32945811, 3, 5), (33013601, 3, 4), (33113884, 3, 2), (33215472, 3, 5), (33336279, 3, 3), (33497711, 3, 3), (33520999, 3, 4), (33626447, 3, 3), (33772449, 3, 2), (33899156, 3, 2), (33990597, 3, 4), (34071761, 3, 3), (34169580, 3, 2), (34251381, 3, 3), (34354255, 3, 5), (34456530, 3, 4), (34543003, 3, 2), (34644296, 3, 4), (34761793, 3, 5), (34870416, 3, 4), (34999476, 3, 4), (35067439, 3, 4), (4085112, 4, 3), (4153051, 4, 4), (4274383, 4, 5), (4318928, 4, 5), (4419414, 4, 4), (4583454, 4, 4), (4669591, 4, 3), (4725923, 4, 2), (4878437, 4, 3), (4980699, 4, 5), (41087818, 4, 5), (41143166, 4, 5), (41225157, 4, 4), (41370085, 4, 5), (41479706, 4, 2), (41589104, 4, 4), (41638056, 4, 3), (41798537, 4, 4), (41825871, 4, 3), (41919165, 4, 4), (42016262, 4, 2), (42174528, 4, 3), (42214582, 4, 4), (42342918, 4, 4), (42450703, 4, 4), (42521872, 4, 4), (42627462, 4, 4), (42771753, 4, 3), (42862864, 4, 4), (42991072, 4, 5), (43042455, 4, 4), (43117958, 4, 4), (43295194, 4, 5), (43370480, 4, 3), (43444161, 4, 5), (43527147, 4, 4), (43644627, 4, 4), (43725300, 4, 5), (43855127, 4, 2), (43990258, 4, 4), (44014640, 4, 4), (44147318, 4, 4), (44246651, 4, 4), (44385316, 4, 4), (44443797, 4, 5), (44539329, 4, 4), (44666068, 4, 5), (44766353, 4, 5), (44821172, 4, 5), (44916576, 4, 3), (45033129, 4, 3), (5027578, 5, 2), (5191251, 5, 5), (5293937, 5, 5), (5334857, 5, 3), (5442513, 5, 5), (5512534, 5, 5), (5692938, 5, 4), (5755027, 5, 3), (5854538, 5, 2), (5993352, 5, 5), (51073745, 5, 5), (51124237, 5, 2), (51221691, 5, 3), (51318462, 5, 3), (51434459, 5, 4), (51572637, 5, 5), (51624505, 5, 4), (51747244, 5, 3), (51884634, 5, 4), (51927861, 5, 3), (52062625, 5, 4), (52147964, 5, 5), (52225468, 5, 4), (52396590, 5, 4), (52493125, 5, 2), (52549935, 5, 5), (52692503, 5, 5), (52710460, 5, 5), (52818370, 5, 4), (52945160, 5, 3), (53033248, 5, 4), (53117203, 5, 3), (53247569, 5, 4), (53327770, 5, 4), (53455434, 5, 2), (53515040, 5, 5), (53698729, 5, 2), (53726777, 5, 3), (53868418, 5, 4), (53985814, 5, 3), (54087321, 5, 5), (54161352, 5, 5), (54293634, 5, 2), (54397866, 5, 4), (54432628, 5, 4), (54535468, 5, 4), (54619131, 5, 4), (54750320, 5, 4), (54889060, 5, 3), (54969841, 5, 5), (55014713, 5, 3), (6063557, 6, 5), (6136106, 6, 4), (6297469, 6, 4), (6395072, 6, 2), (6445159, 6, 4), (6563980, 6, 3), (6650723, 6, 3), (6753111, 6, 3), (6828978, 6, 3), (6999764, 6, 5), (61095084, 6, 3), (61161122, 6, 4), (61232490, 6, 3), (61387806, 6, 2), (61496276, 6, 3), (61552095, 6, 3), (61610132, 6, 2), (61725241, 6, 4), (61848012, 6, 3), (61940854, 6, 5), (62075519, 6, 3), (62123725, 6, 4), (62227006, 6, 2), (62337904, 6, 4), (62462423, 6, 4), (62561228, 6, 4), (62638286, 6, 3), (62716360, 6, 3), (62859715, 6, 2), (62981788, 6, 2), (63034124, 6, 3), (63137593, 6, 4), (63244783, 6, 5), (63319693, 6, 5), (63485442, 6, 3), (63578480, 6, 2), (63649959, 6, 4), (63732465, 6, 3), (63832134, 6, 3), (63968081, 6, 5), (64089161, 6, 4), (64142195, 6, 4), (64256360, 6, 5), (64360724, 6, 3), (64423645, 6, 5), (64582360, 6, 3), (64634893, 6, 4), (64728729, 6, 4), (64869829, 6, 4), (64963504, 6, 5), (65017832, 6, 4), (7096293, 7, 3), (7162595, 7, 3), (7292257, 7, 3), (7372968, 7, 3), (7489126, 7, 2), (7551090, 7, 3), (7656893, 7, 4), (7714562, 7, 4), (7831707, 7, 3), (7952470, 7, 4), (71014649, 7, 5), (71177368, 7, 5), (71240291, 7, 3), (71333956, 7, 2), (71480402, 7, 2), (71588393, 7, 4), (71667549, 7, 4), (71728275, 7, 3), (71860300, 7, 4), (71997227, 7, 4), (72022539, 7, 2), (72122936, 7, 2), (72299896, 7, 5), (72332064, 7, 4), (72424863, 7, 4), (72532962, 7, 3), (72624512, 7, 3), (72728502, 7, 3), (72811177, 7, 5), (72988504, 7, 4), (73030007, 7, 2), (73129546, 7, 3), (73287169, 7, 4), (73341353, 7, 4), (73417449, 7, 4), (73515655, 7, 5), (73635642, 7, 4), (73775146, 7, 4), (73898448, 7, 5), (73923013, 7, 4), (74080053, 7, 3), (74157137, 7, 5), (74276725, 7, 4), (74367996, 7, 3), (74449476, 7, 3), (74518979, 7, 3), (74668808, 7, 4), (74724911, 7, 3), (74890213, 7, 4), (74951995, 7, 3), (75011296, 7, 4), (8084929, 8, 3), (8120038, 8, 3), (8267560, 8, 5), (8312495, 8, 4), (8486593, 8, 4), (8510686, 8, 3), (8660310, 8, 5), (8739741, 8, 4), (8820123, 8, 5), (8967473, 8, 2), (81046137, 8, 5), (81198957, 8, 3), (81213383, 8, 4), (81398936, 8, 5), (81482042, 8, 4), (81558404, 8, 4), (81653423, 8, 5), (81751051, 8, 3), (81898995, 8, 3), (81944176, 8, 4), (82057400, 8, 5), (82146010, 8, 5), (82263072, 8, 3), (82341370, 8, 5), (82412223, 8, 4), (82568533, 8, 2), (82661392, 8, 2), (82711953, 8, 4), (82860011, 8, 3), (82921781, 8, 4), (83062410, 8, 2), (83154587, 8, 4), (83267183, 8, 2), (83338517, 8, 3), (83478447, 8, 3), (83520633, 8, 2), (83626355, 8, 2), (83773521, 8, 4), (83841074, 8, 4), (83954735, 8, 3), (84096186, 8, 4), (84130688, 8, 4), (84290367, 8, 2), (84330025, 8, 3), (84484314, 8, 5), (84515568, 8, 4), (84699672, 8, 3), (84763912, 8, 4), (84836612, 8, 5), (84992566, 8, 3), (85030678, 8, 4), (9064655, 9, 5), (9159090, 9, 4), (9252540, 9, 4), (9345360, 9, 4), (9485514, 9, 2), (9586179, 9, 4), (9665479, 9, 4), (9774946, 9, 2), (9857845, 9, 4), (9929151, 9, 5), (91059817, 9, 4), (91110995, 9, 4), (91230239, 9, 4), (91394850, 9, 5), (91426210, 9, 3), (91593506, 9, 4), (91655528, 9, 5), (91749986, 9, 2), (91876215, 9, 4), (91995905, 9, 4), (92073958, 9, 5), (92140549, 9, 3), (92258128, 9, 3), (92343328, 9, 3), (92498616, 9, 3), (92598258, 9, 4), (92687064, 9, 2), (92730163, 9, 4), (92823520, 9, 3), (92977549, 9, 5), (93074901, 9, 4), (93119815, 9, 5), (93236277, 9, 3), (93337249, 9, 3), (93484869, 9, 2), (93581333, 9, 4), (93616932, 9, 2), (93726564, 9, 5), (93860870, 9, 4), (93928481, 9, 4), (94066867, 9, 3), (94165462, 9, 3), (94258621, 9, 2), (94344785, 9, 5), (94467193, 9, 4), (94563666, 9, 5), (94678606, 9, 5), (94786028, 9, 5), (94833387, 9, 3), (94973649, 9, 3), (95089300, 9, 5), (10078014, 10, 4), (10141939, 10, 4), (10269891, 10, 3), (10384441, 10, 3), (10434013, 10, 3), (10527761, 10, 4), (10646973, 10, 5), (10794730, 10, 2), (10869025, 10, 4), (10925104, 10, 2), (101068855, 10, 5), (101161722, 10, 5), (101268476, 10, 4), (101352324, 10, 5), (101498371, 10, 4), (101542084, 10, 5), (101639829, 10, 5), (101748817, 10, 5), (101875736, 10, 3), (101999700, 10, 4), (102018996, 10, 5), (102194574, 10, 4), (102256025, 10, 4), (102331157, 10, 4), (102471956, 10, 4), (102542253, 10, 4), (102668892, 10, 4), (102793036, 10, 3), (102899481, 10, 3), (102933107, 10, 3), (103042973, 10, 2), (103123907, 10, 5), (103263897, 10, 3), (103331237, 10, 4), (103429383, 10, 5), (103535063, 10, 5), (103628661, 10, 4), (103738312, 10, 5), (103876818, 10, 5), (103912831, 10, 3), (104033715, 10, 5), (104145762, 10, 4), (104248657, 10, 5), (104351929, 10, 4), (104412397, 10, 4), (104526476, 10, 4), (104657489, 10, 3), (104763638, 10, 5), (104817072, 10, 2), (104942778, 10, 4), (105044087, 10, 4), (11097047, 11, 3), (11123637, 11, 5), (11250056, 11, 4), (11369347, 11, 3), (11450947, 11, 4), (11536833, 11, 4), (11655629, 11, 4), (11730071, 11, 4), (11857542, 11, 4), (11969190, 11, 2), (111090608, 11, 2), (111113759, 11, 4), (111226548, 11, 5), (111354826, 11, 3), (111445328, 11, 2), (111522442, 11, 4), (111650459, 11, 3), (111736506, 11, 2), (111815208, 11, 4), (111917465, 11, 4), (112099518, 11, 3), (112117522, 11, 4), (112279159, 11, 2), (112349981, 11, 3), (112481182, 11, 5), (112534257, 11, 4), (112671264, 11, 4), (112796758, 11, 5), (112811917, 11, 2), (112967227, 11, 4), (113090609, 11, 5), (113112702, 11, 5), (113230069, 11, 4), (113346990, 11, 4), (113471691, 11, 4), (113519671, 11, 2), (113636589, 11, 5), (113794454, 11, 4), (113849556, 11, 5), (113929824, 11, 3), (114028244, 11, 3), (114156756, 11, 4), (114268370, 11, 4), (114337400, 11, 5), (114473133, 11, 3), (114529740, 11, 3), (114681678, 11, 4), (114799065, 11, 3), (114824606, 11, 5), (114992323, 11, 4), (115086842, 11, 5), (12083015, 12, 4), (12131992, 12, 3), (12251398, 12, 4), (12381177, 12, 2), (12424088, 12, 5), (12599469, 12, 2), (12625749, 12, 5), (12772094, 12, 4), (12898783, 12, 2), (12989271, 12, 5), (121098155, 12, 4), (121159071, 12, 3), (121247980, 12, 4), (121390204, 12, 5), (121434525, 12, 2), (121559622, 12, 4), (121687697, 12, 5), (121719638, 12, 3), (121881681, 12, 3), (121927289, 12, 5), (122075997, 12, 2), (122124968, 12, 3), (122272847, 12, 4), (122388256, 12, 5), (122493088, 12, 2), (122531893, 12, 4), (122649731, 12, 4), (122756669, 12, 5), (122846582, 12, 4), (122923400, 12, 4), (123069897, 12, 4), (123153226, 12, 3), (123274235, 12, 3), (123377825, 12, 4), (123485340, 12, 2), (123594617, 12, 4), (123667943, 12, 4), (123714423, 12, 4), (123896958, 12, 4), (123913028, 12, 3), (124020205, 12, 3), (124194369, 12, 3), (124279827, 12, 4), (124392063, 12, 5), (124417999, 12, 4), (124522248, 12, 5), (124621164, 12, 4), (124795966, 12, 3), (124828836, 12, 5), (124978624, 12, 5), (125015209, 12, 5), (13027947, 13, 4), (13142772, 13, 4), (13271288, 13, 4), (13336532, 13, 4), (13471541, 13, 5), (13533957, 13, 4), (13697309, 13, 2), (13731664, 13, 5), (13880995, 13, 4), (13952089, 13, 4), (131060033, 13, 5), (131127006, 13, 4), (131287409, 13, 3), (131382880, 13, 4), (131419172, 13, 4), (131592242, 13, 2), (131666083, 13, 2), (131740712, 13, 3), (131816728, 13, 5), (131999430, 13, 5), (132070293, 13, 3), (132151214, 13, 4), (132214997, 13, 4), (132338638, 13, 4), (132493431, 13, 3), (132589137, 13, 4), (132648073, 13, 2), (132768145, 13, 2), (132896147, 13, 5), (132967477, 13, 2), (133086015, 13, 5), (133122814, 13, 2), (133239884, 13, 5), (133394982, 13, 4), (133441778, 13, 5), (133563029, 13, 3), (133657376, 13, 5), (133723405, 13, 4), (133885070, 13, 2), (133991955, 13, 5), (134058171, 13, 4), (134116621, 13, 5), (134249667, 13, 3), (134397545, 13, 3), (134493204, 13, 4), (134543089, 13, 3), (134672890, 13, 4), (134743936, 13, 3), (134880965, 13, 4), (134945276, 13, 4), (135055911, 13, 4), (14024232, 14, 5), (14161835, 14, 5), (14248342, 14, 2), (14342403, 14, 4), (14459690, 14, 3), (14572608, 14, 3), (14622216, 14, 3), (14760330, 14, 3), (14893450, 14, 2), (14923305, 14, 5), (141034958, 14, 4), (141119709, 14, 4), (141219022, 14, 3), (141359904, 14, 2), (141412055, 14, 3), (141562532, 14, 4), (141625073, 14, 4), (141725903, 14, 3), (141843602, 14, 4), (141968997, 14, 2), (142092005, 14, 4), (142199793, 14, 4), (142268358, 14, 3), (142363328, 14, 4), (142494750, 14, 2), (142563235, 14, 4), (142630710, 14, 5), (142772943, 14, 4), (142832237, 14, 3), (142976971, 14, 4), (143084628, 14, 2), (143177934, 14, 2), (143275664, 14, 2), (143391924, 14, 4), (143489047, 14, 4), (143568488, 14, 4), (143648577, 14, 3), (143741184, 14, 4), (143843922, 14, 3), (143952330, 14, 5), (144098311, 14, 3), (144166901, 14, 4), (144286841, 14, 3), (144356299, 14, 2), (144475182, 14, 4), (144564565, 14, 4), (144648255, 14, 3), (144771846, 14, 4), (144896098, 14, 4), (144920436, 14, 5), (145060154, 14, 5), (15025631, 15, 4), (15149198, 15, 3), (15292647, 15, 4), (15367333, 15, 3), (15430180, 15, 4), (15534415, 15, 2), (15632376, 15, 4), (15731597, 15, 4), (15821023, 15, 4), (15945098, 15, 5), (151015281, 15, 3), (151119435, 15, 3), (151215673, 15, 5), (151334205, 15, 3), (151494668, 15, 5), (151539721, 15, 3), (151632015, 15, 5), (151713533, 15, 4), (151832984, 15, 3), (151942532, 15, 4), (152072157, 15, 3), (152120256, 15, 4), (152247346, 15, 5), (152328718, 15, 4), (152429679, 15, 3), (152550292, 15, 4), (152621623, 15, 4), (152740096, 15, 4), (152860582, 15, 4), (152990445, 15, 3), (153077570, 15, 3), (153182563, 15, 4), (153238504, 15, 5), (153325877, 15, 4), (153454466, 15, 4), (153551246, 15, 4), (153649396, 15, 4), (153759621, 15, 4), (153892870, 15, 4), (153911415, 15, 4), (154051071, 15, 4), (154126841, 15, 5), (154253789, 15, 3), (154336979, 15, 4), (154480062, 15, 5), (154560496, 15, 4), (154646758, 15, 4), (154758540, 15, 2), (154816615, 15, 4), (154914454, 15, 4), (155028625, 15, 5), (16031988, 16, 2), (16114155, 16, 5), (16261851, 16, 3), (16331412, 16, 4), (16481309, 16, 4), (16533029, 16, 4), (16631872, 16, 4), (16751347, 16, 4), (16830791, 16, 4), (16927806, 16, 5), (161022707, 16, 4), (161163678, 16, 3), (161239187, 16, 5), (161354432, 16, 4), (161491787, 16, 4), (161563020, 16, 2), (161699205, 16, 4), (161741808, 16, 4), (161876767, 16, 4), (161922603, 16, 4), (162021433, 16, 4), (162184504, 16, 4), (162220529, 16, 5), (162361169, 16, 4), (162454862, 16, 5), (162565394, 16, 4), (162612983, 16, 3), (162724032, 16, 5), (162833020, 16, 4), (162973275, 16, 3), (163061369, 16, 4), (163141242, 16, 5), (163271618, 16, 5), (163372724, 16, 4), (163493934, 16, 3), (163546337, 16, 3), (163647347, 16, 4), (163734481, 16, 4), (163841574, 16, 3), (163925025, 16, 4), (164036110, 16, 3), (164159317, 16, 5), (164278347, 16, 3), (164377447, 16, 4), (164498235, 16, 3), (164558728, 16, 2), (164613647, 16, 5), (164776696, 16, 5), (164899341, 16, 4), (164960747, 16, 2), (165033617, 16, 5); -- SELECT COUNT(*) FROM students; -- SELECT COUNT(*) FROM marks; -- SELECT student_id, COUNT(val) -- FROM marks -- WHERE val = 3 -- GROUP BY student_id; -- SELECT student_id, COUNT(val) -- FROM marks -- WHERE val = 5 -- GROUP BY student_id; SELECT students.name, SUM(marks.val = 5) FROM students INNER JOIN marks ON students.id = marks.student_id GROUP BY students.id HAVING SUM(marks.val = 3) < 10;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear