{"id":3190,"date":"2023-10-21T23:19:05","date_gmt":"2023-10-21T15:19:05","guid":{"rendered":"https:\/\/white-night.club\/?p=3190"},"modified":"2023-11-09T11:07:47","modified_gmt":"2023-11-09T03:07:47","slug":"ad81","status":"publish","type":"post","link":"https:\/\/white-night.club\/index.php\/2023\/10\/21\/ad81\/","title":{"rendered":"596.\u00a0\u8d85\u8fc75\u540d\u5b66\u751f\u7684\u8bfe"},"content":{"rendered":"\n<p>SQL Schema<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Pandas Schema<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u8868:&nbsp;<code>Courses<\/code><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">+-------------+---------+\n| Column Name | Type    |\n+-------------+---------+\n| student     | varchar |\n| class       | varchar |\n+-------------+---------+\n\u5728 SQL \u4e2d\uff0c(student, class)\u662f\u8be5\u8868\u7684\u4e3b\u952e\u5217\u3002\n\u8be5\u8868\u7684\u6bcf\u4e00\u884c\u8868\u793a\u5b66\u751f\u7684\u540d\u5b57\u548c\u4ed6\u4eec\u6ce8\u518c\u7684\u73ed\u7ea7\u3002\n<\/pre>\n\n\n\n<p>\u67e5\u8be2&nbsp;<strong>\u81f3\u5c11\u67095\u4e2a\u5b66\u751f<\/strong>&nbsp;\u7684\u6240\u6709\u73ed\u7ea7\u3002<\/p>\n\n\n\n<p>\u4ee5&nbsp;<strong>\u4efb\u610f\u987a\u5e8f&nbsp;<\/strong>\u8fd4\u56de\u7ed3\u679c\u8868\u3002<\/p>\n\n\n\n<p>\u67e5\u8be2\u7ed3\u679c\u683c\u5f0f\u5982\u4e0b\u6240\u793a\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b 1:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>\u8f93\u5165:<\/strong> \nCourses table:\n+---------+----------+\n| student | class    |\n+---------+----------+\n| A       | Math     |\n| B       | English  |\n| C       | Math     |\n| D       | Biology  |\n| E       | Math     |\n| F       | Computer |\n| G       | Math     |\n| H       | Math     |\n| I       | Math     |\n+---------+----------+\n<strong>\u8f93\u51fa:<\/strong> \n+---------+ \n| class &nbsp; | \n+---------+ \n| Math &nbsp; &nbsp;| \n+---------+\n<strong>\u89e3\u91ca: <\/strong>\n-\u6570\u5b66\u8bfe\u67096\u4e2a\u5b66\u751f\uff0c\u6240\u4ee5\u6211\u4eec\u5305\u62ec\u5b83\u3002\n-\u82f1\u8bed\u8bfe\u67091\u540d\u5b66\u751f\uff0c\u6240\u4ee5\u6211\u4eec\u4e0d\u5305\u62ec\u5b83\u3002\n-\u751f\u7269\u8bfe\u67091\u540d\u5b66\u751f\uff0c\u6240\u4ee5\u6211\u4eec\u4e0d\u5305\u62ec\u5b83\u3002\n-\u8ba1\u7b97\u673a\u8bfe\u67091\u4e2a\u5b66\u751f\uff0c\u6240\u4ee5\u6211\u4eec\u4e0d\u5305\u62ec\u5b83\u3002<\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<blockquote class=\"wp-block-quote has-luminous-vivid-amber-color has-text-color\">\n<p>\u89e3\u9898\u601d\u8def<\/p>\n<cite><em>\u6478\u9c7c<\/em><\/cite><\/blockquote>\n\n\n\n<p>\u4eca\u5929\u5468\u516d\uff0c\u5b9e\u5728\u4e0d\u60f3\u5199\u9898\u3002\u6240\u4ee5\u627e\u5230\u7b80\u5355\u9898\u6478\u4e2a\u9c7c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Write your MySQL query statement below\r\nSELECT class\r\nFROM Courses\r\nGROUP BY class\r\nHAVING COUNT(student)>=5<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Leetcode\u9898\u76ee\uff1a\u6478\u9c7c\u9898<\/p>\n","protected":false},"author":1,"featured_media":2827,"comment_status":"open","ping_status":"","sticky":false,"template":"base","format":"standard","meta":{"footnotes":""},"categories":[42,25],"tags":[38],"_links":{"self":[{"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/posts\/3190"}],"collection":[{"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/comments?post=3190"}],"version-history":[{"count":0,"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/posts\/3190\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/media\/2827"}],"wp:attachment":[{"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/media?parent=3190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/categories?post=3190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/white-night.club\/index.php\/wp-json\/wp\/v2\/tags?post=3190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}