菊头蝙蝠的博客

leetcode-SQL-262. 行程和用户题目解题题目题目链接表：Trips+-------------+----------+| Column Name | Type |+-------------+----------+| id | int || client_id | int || driver_id | int || city_id | int || status | enum

leetcode-SQL-550. 游戏玩法分析 IV题目解题题目题目链接Table: Activity+--------------+---------+| Column Name | Type |+--------------+---------+| player_id | int || device_id | int || event_date | date || games_played | int |+----------

leetcode-SQL-1341. 电影评分题目解题题目题目链接表：Movies+---------------+---------+| Column Name | Type |+---------------+---------+| movie_id | int || title | varchar |+---------------+---------+movie_id 是这个表的主键。title 是电影的名字。表：Users+-

leetcode-SQL-1867. 最大数量高于平均水平的订单题目解题题目题目链接OrdersDetails 表+-------------+------+| Column Name | Type |+-------------+------+| order_id | int || product_id | int || quantity | int |+-------------+------+(order_id, product_id) 是此表的主键。单个订

leetcode-SQL-1045. 买下所有产品的客户题目解题题目题目链接Customer 表：+-------------+---------+| Column Name | Type |+-------------+---------+| customer_id | int || product_key | int |+-------------+---------+product_key 是 Customer 表的外键。Product 表：+-----

leetcode-SQL-1321. 餐馆营业额变化增长题目解题题目题目链接表: Customer+---------------+---------+| Column Name | Type |+---------------+---------+| customer_id | int || name | varchar || visited_on | date || amount | int |+------

leetcode-SQL-1549. 每件商品的最新订单题目解题题目题目链接表: Customers+---------------+---------+| Column Name | Type |+---------------+---------+| customer_id | int || name | varchar |+---------------+---------+customer_id 是该表主键.该表包含消费者的信息.表

leetcode-SQL-1988. 找出每所学校的最低分数要求题目解题题目题目链接表： Schools+-------------+------+| Column Name | Type |+-------------+------+| school_id | int || capacity | int |+-------------+------+school_id 是该表的主键。此表包含了一些学校的容纳能力。容纳能力指的是学校能够接纳学生的最大数量。表： Exa

leetcode-SQL-180. 连续出现的数字题目解题题目题目链接表：Logs+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || num | varchar |+-------------+---------+id 是这个表的主键。编写一个 SQL 查询，查找所有至少连续出现三次的数字。返回的结果表中的数据可以

leetcode-SQL-1459. 矩形面积题目解题题目题目链接表: Points+---------------+---------+| Column Name | Type |+---------------+---------+| id | int || x_value | int || y_value | int |+---------------+---------+id 是该表主键每个点都用

leetcode-SQL-181. 超过经理收入的员工题目解题题目题目链接表：Employee+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar || salary | int || managerId | int |+-------------+--------

leetcode-SQL-1747. 应该被禁止的 Leetflex 账户题目解题题目题目链接表: LogInfo+-------------+----------+| Column Name | Type |+-------------+----------+| account_id | int || ip_address | int || login | datetime || logout | datetime |+-----

leetcode-SQL-1731. 每位经理的下属员工数量题目解题题目题目链接Table: Employees+-------------+----------+| Column Name | Type |+-------------+----------+| employee_id | int || name | varchar || reports_to | int || age | int |+------

leetcode-SQL-603. 连续空余座位题目解题方法一：笛卡尔积题目题目链接表: Cinema+-------------+------+| Column Name | Type |+-------------+------+| seat_id | int || free | bool |+-------------+------+Seat_id是该表的自动递增主键列。该表的每一行表示第i个座位是否空闲。1表示空闲，0表示被占用。编写一个SQL查询

leetcode-SQL-1164. 指定日期的产品价格题目解题题目题目链接产品数据表: Products+---------------+---------+| Column Name | Type |+---------------+---------+| product_id | int || new_price | int || change_date | date |+---------------+---------+这张表

leetcode-SQL-1783. 大满贯数量题目解题方法一：方法二：题目题目链接表：Players+----------------+---------+| Column Name | Type |+----------------+---------+| player_id | int || player_name | varchar |+----------------+---------+player_id 是这个表的主键这个表的每一行给出

leetcode-SQL-626. 换座位题目解题题目题目链接表: Seat+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar |+-------------+---------+Id是该表的主键列。该表的每一行都表示学生的姓名和ID。Id是一个连续的增量。编写SQL查询来交换每两个连续

leetcode-SQL-1294. 不同国家的天气类型题目解题题目题目链接国家表：Countries+---------------+---------+| Column Name | Type |+---------------+---------+| country_id | int || country_name | varchar |+---------------+---------+country_id 是这张表的主键。该表的每行有 countr

leetcode-SQL-580. 统计各专业学生人数题目解题题目题目链接表: Student+--------------+---------+| Column Name | Type |+--------------+---------+| student_id | int || student_name | varchar || gender | varchar || dept_id | int |+--------------+

leetcode-SQL-184. 部门工资最高的员工题目解题题目题目链接表： Employee+--------------+---------+| 列名 | 类型 |+--------------+---------+| id | int || name | varchar || salary | int || departmentId | int |+--------------+--

leetcode-SQL-1501. 可以放心投资的国家题目解题方法一：题目题目链接表 Person:+----------------+---------+| Column Name | Type |+----------------+---------+| id | int || name | varchar || phone_number | varchar |+----------------+---------

leetcode-SQL-1280. 学生们参加各科测试的次数题目解题题目题目链接学生表: Students+---------------+---------+| Column Name | Type |+---------------+---------+| student_id | int || student_name | varchar |+---------------+---------+主键为 student_id（学生ID），该表内的每一行都记

leetcode-SQL-1303. 求团队人数题目解题窗口函数题目题目链接员工表：Employee+---------------+---------+| Column Name | Type |+---------------+---------+| employee_id | int || team_id | int |+---------------+---------+employee_id 字段是这张表的主键，表中的每一行都包含每个员

leetcode-SQL-570. 至少有5名直接下属的经理题目解题方法一：子查询方法二：联结题目题目链接表: Employee+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar || department | varchar || managerId | int |+-----

leetcode-SQL-1264. 页面推荐题目解题题目题目链接朋友关系列表： Friendship+---------------+---------+| Column Name | Type |+---------------+---------+| user1_id | int || user2_id | int |+---------------+---------+这张表的主键是 (user1_id, user2_id)。这张表

leetcode-SQL-1440. 计算布尔表达式的值题目解题题目题目链接表 Variables:+---------------+---------+| Column Name | Type |+---------------+---------+| name | varchar || value | int |+---------------+---------+name 是该表主键.该表包含了存储的变量及其对应的值.表

leetcode-SQL-1398. 购买了产品 A 和产品 B 却没有购买产品 C 的顾客题目解题题目题目链接Customers 表：+---------------------+---------+| Column Name | Type |+---------------------+---------+| customer_id | int || customer_name | varchar |+-------------

leetcode-SQL-1112. 每位学生的最高成绩题目解题题目题目链接表：Enrollments+---------------+---------+| Column Name | Type |+---------------+---------+| student_id | int || course_id | int || grade | int |+---------------+---------+(stud

leetcode-SQL-619. 只出现一次的最大数字题目解题题目题目链接MyNumbers 表：+-------------+------+| Column Name | Type |+-------------+------+| num | int |+-------------+------+这张表没有主键。可能包含重复数字。这张表的每一行都含有一个整数。单一数字 是在 MyNumbers 表中只出现一次的数字。请你编写一个 SQL 查询来报告最大的 单一

leetcode-SQL-1607. 没有卖出的卖家题目解题题目题目链接表: Customer+---------------+---------+| Column Name | Type |+---------------+---------+| customer_id | int || customer_name | varchar |+---------------+---------+customer_id 是该表主键.该表的每行包含网上商城的每一位顾客的

leetcode-SQL-1211. 查询结果的质量和占比题目解题题目题目链接查询表 Queries：+-------------+---------+| Column Name | Type |+-------------+---------+| query_name | varchar || result | varchar || position | int || rating | int |+-------------+----

leetcode-SQL-1173. 即时食物配送 I题目解题题目题目链接配送表: Delivery+-----------------------------+---------+| Column Name | Type |+-----------------------------+---------+| delivery_id | int || customer_id | in

leetcode-SQL-1633. 各赛事的用户注册率题目解题题目题目链接用户表： Users+-------------+---------+| Column Name | Type |+-------------+---------+| user_id | int || user_name | varchar |+-------------+---------+user_id 是该表的主键。该表中的每行包括用户 ID 和用户名。注册表： Regist

leetcode-SQL-1193. 每月交易 I题目解题题目题目链接Table: Transactions+---------------+---------+| Column Name | Type |+---------------+---------+| id | int || country | varchar || state | enum || amount | int ||

leetcode-SQL-1445. 苹果和桔子题目解题题目题目链接表: Sales+---------------+---------+| Column Name | Type |+---------------+---------+| sale_date | date || fruit | enum | | sold_num | int | +---------------+---------+(sale_date,f

leetcode-SQL-1571. 仓库经理题目解题题目题目链接表: Warehouse+--------------+---------+| Column Name | Type |+--------------+---------+| name | varchar || product_id | int || units | int |+--------------+---------+(name, product_id)

leetcode-SQL-1251. 平均售价题目解题题目题目链接Table: Prices+---------------+---------+| Column Name | Type |+---------------+---------+| product_id | int || start_date | date || end_date | date || price | int |+---------

leetcode-SQL-1699. 两人之间的通话次数题目解题方法一：方法二：题目题目链接表： Calls+-------------+---------+| Column Name | Type |+-------------+---------+| from_id | int || to_id | int || duration | int |+-------------+---------+该表没有主键，可能存在重复项。

leetcode-SQL-1084. 销售分析III题目解题题目题目链接Table: Product+--------------+---------+| Column Name | Type |+--------------+---------+| product_id | int || product_name | varchar || unit_price | int |+--------------+---------+Product_id是该表

leetcode-SQL-1587. 银行账户概要 II题目解题题目题目链接表: Users+--------------+---------+| Column Name | Type |+--------------+---------+| account | int || name | varchar |+--------------+---------+account 是该表的主键.表中的每一行包含银行里中每一个用户的账号.表: Tr