| /* | |
| * 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 dt.d_year | |
| ,item.i_brand_id brand_id | |
| ,item.i_brand brand | |
| ,sum(ss_sales_price) sum_agg | |
| from date_dim dt | |
| ,store_sales | |
| ,item | |
| where dt.d_date_sk = store_sales.ss_sold_date_sk | |
| and store_sales.ss_item_sk = item.i_item_sk | |
| and item.i_manufact_id = 30 | |
| and dt.d_moy=12 | |
| group by dt.d_year | |
| ,item.i_brand | |
| ,item.i_brand_id | |
| order by dt.d_year | |
| ,sum_agg desc | |
| ,brand_id | |
| LIMIT 100 |