select a.groupid,a.total_kill,
count(a.total_kill) as frequency
from
(select groupid,matchid,
sum(kills) as total_kill
from juediqs
group by groupid) a
group by total_kill
order by frequency asc limit 100;

create table ds_indian_restarants_price
select f1 as item_name, f2 as product_price, ‘res_1‘ as brand_tag
from restaurant1
union ALL
select f1 as item_name, f2 as product_price, ‘res_2‘ as brand_tag
from restaurant2;

create table total_indian_restaurant_order_price
SELECT a.`order number` as order_number,
a.`order date` as order_date,
a.`item name` as item_name,
a.quantity,a.brand_tag,
a.`total products` as products_number, 
b.product_price
from ds_indian_restaurants_orders a JOIN
ds_indian_restarants_price b ON
a.`item name` = b.item_name and a.brand_tag=b.brand_tag;