{"queries":[{"id":"src","compiledQueryString":"select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\"","inputQueryString":"select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\"","compiled":false,"inline":true},{"id":"kpis","compiledQueryString":"select count(distinct \"order_id\") as \"orders\", sum(\"Sum of total_order\") as \"sales\", count(distinct \"member_id\") as \"customers\" from (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")","inputQueryString":"select count(distinct \"order_id\") as \"orders\", sum(\"Sum of total_order\") as \"sales\", count(distinct \"member_id\") as \"customers\" from ${src}","compiled":true,"inline":true},{"id":"bymonth","compiledQueryString":"select month(\"New Date\") as \"order\"\n , strftime('%b %Y', \"New Date\") as \"month\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by month(\"New Date\"), strftime('%b %Y', \"New Date\")\norder by 1 asc","inputQueryString":"select month(\"New Date\") as \"order\"\n , strftime('%b %Y', \"New Date\") as \"month\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom ${src}\ngroup by month(\"New Date\"), strftime('%b %Y', \"New Date\")\norder by 1 asc","compiled":true,"inline":true},{"id":"bycity","compiledQueryString":"select \"city\" as \"city\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by \"city\"","inputQueryString":"select \"city\" as \"city\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom ${src}\ngroup by \"city\"","compiled":true,"inline":true},{"id":"bymealtype","compiledQueryString":"select \"meal_type\" as \"meal\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by \"meal_type\"","inputQueryString":"select \"meal_type\" as \"meal\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom ${src}\ngroup by \"meal_type\"","compiled":true,"inline":true},{"id":"bymeal","compiledQueryString":"select \"meal_name\" as \"meal\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\")/\"total\" as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by \"meal_name\", \"total\"\norder by 3","inputQueryString":"select \"meal_name\" as \"meal\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\")/\"total\" as \"sales\"\nfrom ${src}\ngroup by \"meal_name\", \"total\"\norder by 3","compiled":true,"inline":true},{"id":"byrestype","compiledQueryString":"select \"restaurant_type\" as \"restaurant\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by \"restaurant_type\"","inputQueryString":"select \"restaurant_type\" as \"restaurant\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom ${src}\ngroup by \"restaurant_type\"","compiled":true,"inline":true},{"id":"byres","compiledQueryString":"select \"restaurant_name\" as \"restaurant\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\")/\"total\" as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by \"restaurant_name\", \"total\"\norder by 3","inputQueryString":"select \"restaurant_name\" as \"restaurant\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\")/\"total\" as \"sales\"\nfrom ${src}\ngroup by \"restaurant_name\", \"total\"\norder by 3","compiled":true,"inline":true},{"id":"byserve","compiledQueryString":"select \"serve_type\" as \"serve\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by \"serve_type\"","inputQueryString":"select \"serve_type\" as \"serve\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom ${src}\ngroup by \"serve_type\"","compiled":true,"inline":true},{"id":"bycust","compiledQueryString":"select \"first_name\"||' '||\"surname\" as \"customer\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\")/\"total\" as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by \"first_name\"||' '||\"surname\", \"total\"\norder by 3","inputQueryString":"select \"first_name\"||' '||\"surname\" as \"customer\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\")/\"total\" as \"sales\"\nfrom ${src}\ngroup by \"first_name\"||' '||\"surname\", \"total\"\norder by 3","compiled":true,"inline":true},{"id":"byprice","compiledQueryString":"select case \n when \"Sum of Price\" < 180 then '20-30'\n when \"Sum of Price\" < 360 then '30-40'\n when \"Sum of Price\" < 540 then '40-50'\n when \"Sum of Price\" < 720 then '50-60'\n when \"Sum of Price\" < 900 then '60-70'\n else '70-80'\n end as \"price\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom (select sum(\"Sum of total_order\") over(partition by 1) as \"total\", * from \"restaurants\")\ngroup by case \n when \"Sum of Price\" < 180 then '20-30'\n when \"Sum of Price\" < 360 then '30-40'\n when \"Sum of Price\" < 540 then '40-50'\n when \"Sum of Price\" < 720 then '50-60'\n when \"Sum of Price\" < 900 then '60-70'\n else '70-80'\n end\norder by 1","inputQueryString":"select case \n when \"Sum of Price\" < 180 then '20-30'\n when \"Sum of Price\" < 360 then '30-40'\n when \"Sum of Price\" < 540 then '40-50'\n when \"Sum of Price\" < 720 then '50-60'\n when \"Sum of Price\" < 900 then '60-70'\n else '70-80'\n end as \"price\"\n , count(distinct \"order_id\") as \"orders\"\n , sum(\"Sum of total_order\") as \"sales\"\nfrom ${src}\ngroup by case \n when \"Sum of Price\" < 180 then '20-30'\n when \"Sum of Price\" < 360 then '30-40'\n when \"Sum of Price\" < 540 then '40-50'\n when \"Sum of Price\" < 720 then '50-60'\n when \"Sum of Price\" < 900 then '60-70'\n else '70-80'\n end\norder by 1","compiled":true,"inline":true}]}