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

歡迎光臨散文網(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ó)家法律
天峻县| 古蔺县| 军事| 米林县| 嵩明县| 陆丰市| 成安县| 五华县| 吴堡县| 龙川县| 株洲县| 吉首市| 德州市| 克什克腾旗| 枝江市| 曲水县| 奉贤区| 湄潭县| 永安市| 两当县| 济源市| 台山市| 灵台县| 根河市| 万年县| 凤山市| 上虞市| 新干县| 化德县| 平陆县| 民县| 格尔木市| 大名县| 蒙阴县| 济阳县| 紫金县| 莆田市| 宁海县| 泰顺县| 乾安县| 平顶山市|