最美情侣中文字幕电影,在线麻豆精品传媒,在线网站高清黄,久久黄色视频

歡迎光臨散文網(wǎng) 會(huì)員登陸 & 注冊(cè)

database_leetcode2082. The Number of Rich Customers

2022-02-22 17:42 作者:您是打尖兒還是住店呢  | 我要投稿

Write an SQL query to report the number of customers who had at least one bill with an amount strictly greater than 500.
The query result format is in the following example.

Example 1:
Input: Store table:

+---------+-------------+--------+

| bill_id | customer_id | amount |

+---------+-------------+--------+

| 6 ? ? ? | 1 ? ? ? ? ? | 549 ? ?|

| 8 ? ? ? | 1 ? ? ? ? ? | 834 ? ?|

| 4 ? ? ? | 2 ? ? ? ? ? | 394 ? ?|

| 11 ? ? ?| 3 ? ? ? ? ? | 657 ? ?|

| 13 ? ? ?| 3 ? ? ? ? ? | 257 ? ?|

+---------+-------------+--------+

Output:

+------------+

| rich_count?|

+------------+

| 2 ? ? ? ? ?|

+------------+

Explanation: Customer 1 has two bills with amounts strictly greater than 500.Customer 2 does not have any bills with an amount strictly greater than 500.Customer 3 has one bill with an amount strictly greater than 500.


database_leetcode2082. The Number of Rich Customers的評(píng)論 (共 條)

分享到微博請(qǐng)遵守國(guó)家法律
禄丰县| 柘城县| 江口县| 桃园市| 永德县| 牙克石市| 腾冲县| 凤阳县| 清镇市| 武山县| 大厂| 黄大仙区| 阿瓦提县| 洛南县| 定结县| 遵义县| 如皋市| 密云县| 西畴县| 长沙市| 应城市| 广德县| 库伦旗| 米林县| 翁源县| 台州市| 葫芦岛市| 呼图壁县| 黑水县| 建湖县| 永寿县| 新蔡县| 平谷区| 茌平县| 玛沁县| 怀来县| 鸡东县| 金昌市| 旺苍县| 家居| 通山县|