-
Notifications
You must be signed in to change notification settings - Fork 1.5k
/
query03.sql
23 lines (23 loc) · 1.02 KB
/
query03.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements. See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership. The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License. You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
select lstg_format_name,
sum(sum(price)) over(partition by lstg_format_name),
max(sum(price)) over(partition by lstg_format_name),
min(sum(price)) over(partition by lstg_format_name)
from test_kylin_fact
group by cal_dt, lstg_format_name