{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Queries","DataBase"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Sequel\nQueries"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Queries","index":1,"n_rows":114,"n_cols":7,"rows_kept":114,"cut":false,"hidden":false,"merged":[[111,0,111,1],[112,0,112,1],[113,0,113,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[109,0,109,1],[110,0,110,1],[109,3,109,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[113,3,113,4],[108,3,108,4],[105,6,105,8],[69,6,69,8],[16,6,16,8],[4,6,4,8],[16,0,16,1],[105,0,105,1],[105,3,105,4],[106,3,106,4],[107,3,107,4],[104,0,104,1],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[100,0,100,1],[101,0,101,1],[102,0,102,1],[103,0,103,1],[91,3,91,4],[92,3,92,4],[68,3,68,4],[70,3,70,4],[71,3,71,4],[86,3,86,4],[87,3,87,4],[88,3,88,4],[89,3,89,4],[99,3,99,4],[98,0,98,1],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[90,3,90,4],[99,0,99,1],[93,3,93,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[98,3,98,4],[97,0,97,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[69,3,69,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[3,3,3,5],[65,3,65,4],[66,3,66,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[42,3,42,4],[43,3,43,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[80,3,80,4],[67,3,67,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[86,0,86,1],[87,0,87,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[75,0,75,1],[69,0,69,1],[56,0,56,1],[20,3,20,4],[67,0,67,1],[68,0,68,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[40,0,40,1],[44,3,44,4],[21,3,21,4],[58,0,58,1],[93,0,93,1],[5,3,5,4],[6,3,6,4],[7,3,7,4],[82,0,82,1],[83,0,83,1],[84,0,84,1],[85,0,85,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[88,0,88,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[15,3,15,4],[17,3,17,4],[29,0,29,1],[30,0,30,1],[65,0,65,1],[66,0,66,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[41,0,41,1],[42,0,42,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[4,3,4,4],[16,3,16,4],[8,0,8,1],[21,0,21,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[9,0,9,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[18,3,18,4],[19,3,19,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[7,6,7,8],[8,6,8,8],[3,6,3,8],[6,6,6,8],[9,6,9,8],[10,6,10,8],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[24,6,24,8],[25,6,25,8],[26,6,26,8],[27,6,27,8],[15,6,15,8],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[42,6,42,8],[43,6,43,8],[44,6,44,8],[45,6,45,8],[28,6,28,8],[29,6,29,8],[30,6,30,8],[31,6,31,8],[32,6,32,8],[33,6,33,8],[34,6,34,8],[35,6,35,8],[36,6,36,8],[37,6,37,8],[38,6,38,8],[39,6,39,8],[40,6,40,8],[41,6,41,8],[46,6,46,8],[47,6,47,8],[48,6,48,8],[49,6,49,8],[50,6,50,8],[51,6,51,8],[52,6,52,8],[53,6,53,8],[54,6,54,8],[65,6,65,8],[66,6,66,8],[67,6,67,8],[68,6,68,8],[55,6,55,8],[56,6,56,8],[58,6,58,8],[59,6,59,8],[60,6,60,8],[61,6,61,8],[62,6,62,8],[63,6,63,8],[64,6,64,8],[76,6,76,8],[77,6,77,8],[78,6,78,8],[79,6,79,8],[87,6,87,8],[71,6,71,8],[72,6,72,8],[73,6,73,8],[74,6,74,8],[80,6,80,8],[81,6,81,8],[82,6,82,8],[83,6,83,8],[84,6,84,8],[85,6,85,8],[86,6,86,8],[0,6,1,8],[2,0,2,1],[2,6,2,8],[0,0,1,1],[0,3,1,4],[2,3,2,4],[104,6,104,8],[89,6,89,8],[90,6,90,8],[91,6,91,8],[92,6,92,8],[93,6,93,8],[94,6,94,8],[95,6,95,8],[96,6,96,8],[98,6,98,8],[99,6,99,8],[100,6,100,8],[101,6,101,8],[102,6,102,8],[103,6,103,8],[97,6,97,8],[88,6,88,8],[75,6,75,8]]}
["Query",null,null,"Syntax",null,null,"Sheet Name"]
[]
["Select all columns from Sales table",null,null,"Select * From Sales",null,null,"Star_With_Name"]
["Select all columns from Sales table",null,null,"Select * FROM [Sales]",null,null,"Star_With_Brackets"]
["Select Item Column from Sales table",null,null,"Select Item FROM Sales"," ",null,"Column_Item"]
["Select Item, Quantity Columns from Sales table",null,null,"Select Item,Quantity FROM Sales",null,null,"Item_Qty_Cols"]
["Select Item, Price Column Where Price > 100 from Sales table",null,null,"Select Item,Price FROM Sales where Price > 100"," ",null,"Price_Greaterthan_100"]
["Select Price Column Where   Price < 100 from Sales table",null,null,"Select Price FROM Sales where Price < 100"," ",null,"Price_Lessthan_100"]
["Change the Order Of Sales Table By Item",null,null,"Select * FROM Sales order by Item"," ",null,"OrderByItem"]
["Change the Order Of Sales Table By Price",null,null,"Select * FROM Sales Order by Price"," ",null,"OrderByPrice"]
["Order by Sales Table by first column",null,null,"Select * FROM Sales order by 1"," ",null,"OrderbyFirstcolumn"]
["Order by Sales Table by second column",null,null,"Select * FROM Sales order by 2"," ",null,"OrderbySecondColumn"]
["Order by Item column in Sales Table by Descending",null,null,"Select Item FROM Sales order by Item desc"," ",null,"Item_Desc"]
["Order by Price column in Sales Table by Ascending",null,null,"Select Price FROM Sales order by Price Asc"," ",null,"Price_Asc"]
["Retrieve records from Sales table, where price equal to  90 and   145",null,null,"Select * from Sales where Price >=90 and Price<=145"," ",null,"AND_Operator_Price"]
["Retrieve Item records from Sales table, where Items represents to Apple  or  Banana",null,null,"Select * from Sales where Item='Apple' or Item='Banana'"," ",null,"OR_Operator_Item"]
["Retrieve records from Sales table, where price >=  85 and <=145",null,null,"Select * from Sales where Price  between  85 and  145"," ",null,"Between_Operator_Price"]
["Retrieve Item,Price from Sales table, where price >=  100  and <=150",null,null,"Select Item, Price from Sales where Price between  100 and  150",null,null,"Between_With_Price"]
["Retrieve records from Sales table, where price >=  85 and <=145 Order by Quantity",null,null,"Select * from Sales where Price  between  85 and  145 Order by Quantity"," ",null,"Between_OrderbyQTY"]
["Retrieve records from Sales table, where price not in the range of   85 and  145",null,null,"Select * from Sales where Price  not between  85 and  145"," ",null,"Not_Between_Operator_Price"]
["Retrieve records from Sales table, where Items represents to Apple,Banana,Orange",null,null,"Select * from Sales where Item in('Apple','Banana','Orange')"," ",null,"In_Operator_Item"]
["Retrieve records from Sales table, where Items doesn't represents to Apple,Banana,Orange",null,null,"Select * from Sales where Item not in('Apple','Banana','Orange')"," ",null,"Not_In_Operator_Item"]
["Retrieve records from Sales table, where Price having NULL value",null,null,"Select * from Sales where Price IS Null"," ",null,"IS_Null_Of_Price"]
["Retrieve records from Sales table, where Price having Not NULL value",null,null,"Select * from Sales where Price IS Not Null"," ",null,"IS_Not_Null"]
["Retrieve Length of Item records from Sales table",null,null,"Select Item, len(Item) as Length FROM Sales"," ",null,"Len_Function"]
["Retrieve Item records where Length having >5 from Sales table",null,null,"Select Item, len(Item) as Length FROM Sales where Len(Item)>5"," ",null,"Len_Greaterthan_5"]
["Retrieve Item records where Length is < 7 from Sales table",null,null,"Select Item, len(Item) as Length FROM Sales where Len(Item)<7"," ",null,"Len_Lessthan_7"]
["Retrieve Item records where Length is >=5 and <=8 from Sales table",null,null,"Select Item, len(Item) as Length FROM Sales where Len(Item)>=5 and Len(Item)<=8"," ",null,"Len_Greater_Less_5_8"]
["Select Item Column where Item starts with P from Sales table",null,null,"Select Item FROM Sales where left(Item,1) = 'P'"," ",null,"Item_Starts_with_p"]
["Select Item and Price Columns where Item ends with \"R\" from Sales table",null,null,"Select * FROM Sales where Right(Item,1) = 'r'"," ",null,"Item_Ends_with_r"]
["Select Max Price from Sales table",null,null,"Select Max(Price)  as MaxPrice from  Sales"," ",null,"Max_Price"]
["Select Min Price from Sales table",null,null,"Select Min(Price)  as MinPrice from  Sales"," ",null,"Min_Price"]
["Select Min Price among Apple and Banana from Sales table",null,null,"Select Min(Price)  as MinPrice from  Sales where Item in( 'Apple','Banana' )"," ",null,"Min_Price_Two_Items"]
["Sum the Price of Items where Item starts with \"P\" from Sales table",null,null,"Select Sum(Price)  as SumPrice from  Sales where left(Item,1)='p'"," ",null,"SumOfITemsStartswithP"]
["Sum the QUANTITY of Items where Item Ends with \"e\" from Sales table",null,null,"Select Sum(Quantity)  as SumPrice from  Sales where Right(Item,1)='e'"," ",null,"SumOfITemsEndswithE"]
["Sum the QUANTITY of Items where Price > 100 from Sales table",null,null,"Select Sum(Quantity)  as SumPrice from  Sales where  Price > 100"," ",null,"SumQTYGreaterthan100"]
["Calculate Total Cost of Apple from Sales table",null,null,"Select Item, Price, Quantity,Quantity*Price as TotalCost from Sales where Item = 'Apple' "," ",null,"SumOfApple"]
["Calculate total cost of items having price greater than 100 from Sales table",null,null,"Select Item, Price, Quantity,Quantity*Price as TotalCost from Sales where Price > 100"," ",null,"SumItemsonPrice"]
["Calculate total cost of items having Quantity Less than 2000  from Sales table",null,null,"Select Item, Price, Quantity,Quantity*Price as TotalCost from Sales where Quantity < 2000"," ",null,"SumItemsonQuanity"]
["Count Items from Sales table",null,null,"Select count(Item) as ItemsCount from Sales"," ",null,"Items_Count"]
["Count Items from Sales table where letter starts with M",null,null,"Select count(Item) as ItemsCount from Sales where left(Item, 1) = 'M'"," ",null,"Items_Count_startswith_M"]
["Count Items from Sales table where Quantity greaterthan 3000",null,null,"Select count(Item) as ItemsCount from Sales where Quantity > 3000"," ",null,"Items_Quanity_Greaterthan"]
["Top 3 records based on Price from Sales table",null,null,"Select Top 3 Price from Sales"," ",null,"Top_Three_Pricing"]
["Top 2 records based on Quantity from Sales table",null,null,"Select Top 2 Quantity from Sales"," ",null,"Top_Two_Quantity"]
["Select Top 2 Price, Quantity records from Sales table",null,null,"Select Top 2 Price, Quantity  from Sales"," ",null,"Top_Two_Price_Quantity"]
["Select Top 2  Quantity, Price, Item records from Sales table",null,null,"Select Top 2 Quantity, Price , Item from Sales"," ",null,"Top_Two_Quantity_Price"]
["Select Top 4 of  Quantity, Price, Item records from Sales table Order by Price",null,null,"Select Top 4 Quantity, Price, Item from Sales Order by Price"," ",null,"Top_Four_Orderby_Price"]
["Select Top 4 of  Quantity, Price, Item records from Sales table Order by Quantity",null,null,"Select Top 4 Quantity, Price, Item from Sales Order by Quantity"," ",null,"Top_Four_Orderby_Qty"]
["Select Top 4 of  Quantity, Price, Item records from Sales table where Quantity greater than 2000",null,null,"Select Top 4 Quantity, Price, Item from Sales where Quantity > 2000 Order by Quantity"," ",null,"Qty_In_ASC_Price_In_Desc"]
["Select Top 4 of  Quantity, Price, Item records from Sales table where Quantity greater than 3000",null,null,"Select Top 4 Quantity, Price, Item from Sales where Quantity > 3000 Order by Quantity"," ",null,"TopFour_Threethousand"]
["Select Top 4 records of Price,Item order by Pricing from Sales table",null,null,"Select Top 4   Price, Item from Sales Order by Price desc"," ",null,"TOP_Three_Desc"]
["Retrive records where Item starts with \"B\" from Sales table",null,null,"Select Item,Price,Quantity  from Sales where Item like 'B%'"," ",null,"Item_Starts_with_B"]
["Retrive records where Item starts with \"P\" or \"B\" Order by  Price  in Asc  from Sales table",null,null,"Select Item,Price,Quantity  from Sales where Item like 'P%' or Item like 'B%' Order by Price"," ",null,"Item_Starts_with_B_P"]
["Retrive records where Item starts with \"P\" or Price is less than 100 and Quantity between 2400 to 3000 from Sales table",null,null,"Select * from Sales where(Item like 'P%' or Price < 100 or Quantity between 2300 and 2500)"," ",null,"ItemPriceQty_OR"]
["Retrive records where Item starts with \"P\" or Quantity between 2400 to 3000 from Sales table",null,null,"Select * from Sales where(Item like 'P%' or   Quantity between 2300 and 2500)"," ",null,"Item_Quantity"]
["Remove duplicates from Location column from Region table",null,null,"Select Distinct Location from Region"," ",null,"Loc_remove_dup"]
["Retrieve records which Item starts with \"A\" and Location doesn’t belongs to North from Region table",null,null,"Select * from Region where Item like \"A%\" and Location <> 'North'"," ",null,"Item_Like_Starts_A"]
["Retrieve records which Item Ends with \"A\"",null,null,"Select * from Region where Item like \"%A\" ",null,null,"Item_Like_Ends_A"]
["Add 5 Days to the Dates Column from Region  table",null,null,"Select Dates, Dates + 5 as Daysadded from Region"," ",null,"Add_Days"]
["Deduct 5 Days from the Dates Column from Region table",null,null,"Select Dates, Dates - 5 as 5daysdeducted from Region"," ",null,"Deduct_Days"]
["Select all columns from Region table Orderby date",null,null,"Select * from Region Order by Dates"," ",null,"Order_by_Date"]
["Select all columns from Region table Orderby dates in descending",null,null,"Select * from Region Order by Dates Desc"," ",null,"Order_by_Date_Desc"]
["Order the Sales table by length of Item column",null,null,"Select * from Sales Order by  len(Item) Desc"," ",null,"OrderbyLenItem"]
["Retrieve Dates, Years of dates from Region table",null,null,"Select Dates, year(Dates) as Years from Region"," ",null,"Years_of_Date"]
["Retrieve Item records where Year > 2020  from Region table",null,null,"Select Item,Dates, year(Dates) as Years from Region where Year(Dates) = 2020"," ",null,"YearofDateequals"]
["Retrieve Item records where Year = 2016 from Region table",null,null,"Select Item,Dates, year(Dates) as Years from Region where Year(Dates) = 2021"," ",null,"YearOfdateEQual"]
["Retrieve Dates, Month of dates from Region table",null,null,"Select Dates, Month(Dates) as Months from Region"," ",null,"Retrieve_Month"]
["Retrieve Items,Dates, Month of dates from Region table where month is less than June",null,null,"Select Item,Dates, month(Dates) as Years from Region where month(Dates) <  6"," ",null,"Month_Range"]
["Retrieve Items,Dates, Date of dates from Region table ",null,null,"Select Item,Dates, day(Dates) as DatesDate from Region"," ",null,"Date_Dates"]
["Provide Inner Join between Sales table and Region table",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item"," ",null,"InnerJoin_twotables"]
["Provide Inner Join between Sales table and Region table Retrive Price Column",null,null,"select Sales.Item, Sales.Price, Region.Location from Sales inner join Region on Sales.Item = Region.Item"," ",null,"InnerJoin_Cols_Select"]
["Provide Inner Join between Sales table and Region table Order by Price",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item Order by Price"," ",null,"InnerJoin_Orderby_Price"]
["Retrieve all records of 2020 by providing  Inner Join between Sales table and Region table  ",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item  where year(Dates) = 2020"," ",null,"InnerJoin_By_Year"]
["Retrieve all records of East by providing  Inner Join between Sales table and Region table  ",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item  where Location = 'East'"," ",null,"InnerJoin_Of_Designer"]
["Retrieve all records  by providing  Inner Join between Sales table and Region table  where Quantity between 3000 and 4000",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item  where Sales.Quantity between 3000 and 4000"," ",null,"InnerJoin_Quantity_Between"]
["Retrieve all records  by providing  Inner Join between Sales table and Region table    where ITem starts with \"P\"",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item  where Sales.Item like 'P%'"," ",null,"InnerJoin_Itemwith_P"]
["Retrieve all records  by providing  Inner Join between Sales table and Region table    where Location starts with \"S\"",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item  where Region.Location like 'S%'"," ",null,"InnerJoin_Loc_Starts_S"]
["Retrieve all records  by providing  Inner Join between Sales table and Region table  where Item of Sales table starts with \"A\" or   Location of Region table ends with S",null,null,"select * from Sales inner join Region on Sales.Item = Region.Item  where Sales.Item like 'p%' or Region.Location like '%S'"," ",null,"Innerjoin_Item_User"]
["Retrieve Item,Price,Location records from Sales and Region table by providing Inner Join",null,null,"select Sales.Item, Sales.Price, Region.Location from Sales inner join Region on Sales.Item = Region.Item"," ",null,"Innerjoin_Item_Price_User"]
["Retrieve Item,Price,Location records from Sales and Region table by providing Inner Join where Price > 100",null,null,"select Sales.Item, Sales.Price, Region.Location from Sales inner join Region on Sales.Item = Region.Item where Sales.Price > 100"," ",null,"Innerjoin_Price_Greaterthan"]
["Retrieve Location from Region table where Quantity is greater than 3000 of Sales Table",null,null,"select Sales.Quantity,  Region.Location from Sales inner join Region on Sales.Item = Region.Item where Sales.Quantity > 3000"," ",null,"Innerjoin_QuantityGreater"]
["Provide Left Outer join between Sales table and Region table",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item"," ",null,"LeftOuter_twotables"]
["Provide Left Outer join between Sales table and Region table Order by Price",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item Order by Sales.Price"," ",null,"LeftOuter_Orderby_Price"]
["Retrieve all records of 2016 by providing  Left Outer join between Sales table and Region table  ",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item  where year(Dates) = 2016"," ",null,"LeftOuter_By_Year"]
["Retrieve all records of designer by providing  Left Outer join between Sales table and Region table  ",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item  where Location = 'Designers'"," ",null,"LeftOuter_Of_Designer"]
["Retrieve all records  by providing  Left Outer join between Sales table and Region table  where Quantity between 3000 and 4000",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item  where Sales.Quantity between 3000 and 4000"," ",null,"LeftOuter_Quantity_Between"]
["Retrieve all records  by providing  Left Outer join between Sales table and Region table    where ITem starts with \"P\"",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item  where Sales.Item like 'P%'"," ",null,"LeftOuter_Itemwith_P"]
["Retrieve all records  by providing  Left Outer join between Sales table and Region table    where Location starts with \"S\"",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item  where Region.Location like 'S%'"," ",null,"LeftOuter_Loc_Ends_S"]
["Retrieve all records  by providing  Left Outer join between Sales table and Region table  where Item of Sales table starts with \"P\" or   Location of Region table ends with S",null,null,"select * from Sales Left Outer join Region on Sales.Item = Region.Item  where Sales.Item like 'p%' or Region.Location like '%S'"," ",null,"LeftOuter_Item_Loc"]
["Retrieve Item,Price,Location records from Sales and Region table by providing Left Outer join",null,null,"select Sales.Item, Sales.Price, Region.Location from Sales Left Outer join Region on Sales.Item = Region.Item"," ",null,"LeftOuter_Item_Price_User"]
["Retrieve Item,Price,Location records from Sales and Region table by providing Left Outer join where Price > 100",null,null,"select Sales.Item, Sales.Price, Region.Location from Sales Left Outer join Region on Sales.Item = Region.Item where Sales.Price > 100"," ",null,"LeftOuter_Price_Greaterthan"]
["Retrieve Location from Region table where Quantity is greater than 3000 of Sales Table",null,null,"select Sales.Quantity,  Region.Location from Sales Left Outer join Region on Sales.Item = Region.Item where Sales.Quantity > 3000"," ",null,"LeftOuter_QuantityGreater"]
["Provide Right Outer Join between Sales table and Region table",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item"," ",null,"RightOuter_twotables"]
["Provide Right Outer Join between Sales table and Region table Order by Price",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item Order by Sales.Price"," ",null,"RightOuter_Orderby_Price"]
["Retrieve all records of 2016 by providing  Right Outer Join between Sales table and Region table  ",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item  where year(Dates) = 2016"," ",null,"RightOuter_By_Year"]
["Retrieve all records of designer by providing  Right Outer Join between Sales table and Region table  ",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item  where Location = 'Designers'"," ",null,"RightOuter_Of_Designer"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Region table  where Quantity between 3000 and 4000",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item  where Sales.Quantity between 3000 and 4000"," ",null,"RightOuter_Quantity_Between"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Region table    where ITem starts with \"P\"",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item  where Sales.Item like 'P%'"," ",null,"RightOuter_Itemwith_P"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Region table    where Location starts with \"S\"",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item  where Region.Location like 'S%'"," ",null,"RightOuter_Zone_Starts_With_S"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Region table  where Item of Sales table starts with \"A\" or   Location of Region table ends with t",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item  where Sales.Item like 'A%' or Region.Location like '%t'"," ",null,"RightOuter_Item_Loc"]
["Retrieve Item,Price,Location records from Sales and Region table by providing Right Outer Join",null,null,"select Sales.Item, Sales.Price, Region.Location from Sales Right Outer Join Region on Sales.Item = Region.Item"," ",null,"RightOuter_Item_Price_Loc"]
["Retrieve Item,Price,Location records from Sales and Region table by providing Right Outer Join where Price > 100",null,null,"select Sales.Item, Sales.Price, Region.Location from Sales Right Outer Join Region on Sales.Item = Region.Item where Sales.Price > 100"," ",null,"RightOuter_Price_Greaterthan"]
["Retrieve Location from Region table where Quantity is greater than 3000 of Sales Table",null,null,"select Sales.Quantity,  Region.Location from Sales Right Outer Join Region on Sales.Item = Region.Item where Sales.Quantity > 3000"," ",null,"RightOuter_QuantityGreater"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Region table    where Quantity is less than 2000",null,null,"select * from Sales Right Outer Join Region on Sales.Item = Region.Item  where Sales.Quantity < 2000"," ",null,"RightOuter_Quantity"]
["Retrieve all records  by providing  Left Outer Join between Sales table and Region table    where Quantity is less than 2000",null,null,"select * from Sales Left Outer Join Region on Sales.Item = Region.Item  where Sales.Quantity < 2000"," ",null,"LeftOuter_Quantity"]
["Retrieve all records  by providing  Inner Join between Sales table and Region table    where Quantity is less than 2000",null,null,"select * from Sales Inner  Join Region on Sales.Item = Region.Item  where Sales.Quantity < 2000"," ",null,"InnerJoin_Quantity"]
["Retrieve Records of Item from Sales and Item from Region using UNION operator",null,null,"Select Item from Sales Union Select Item from Region",null,null,"Union_For_Item"]
["Retrieve Records of Item from Sales and Item from Region using UNIONAll operator",null,null,"Select Item from Sales Union All Select Item from Region",null,null,"Union_All_For_Item"]
["Retrieve Items With Group By Clause from Sales Table",null,null,"Select Item from Sales group by Item",null,null,"GroupByItem"]
["Retrieve Items With Group By Clause from Region Table",null,null,"Select Location from Region group by Location",null,null,"GroupByItem_RegionTbl"]
["Combine Item and Location from Region table",null,null,"Select Item, Location  + ', ' +  Item as combo  from Region",null,null,"Combine_Item_Location"]
["Combine Item and Location columns from Region Table",null,null,"Select Item,  Item + '   Sold In  ' +  Location   + ' Zone' as CombineStatement from Region",null,null,"Combine_Price_And_Item"]
["Combine Item and Location columns from Region Table Order by 1",null,null,"Select Item,  Item + '   Sold In  ' +  Location   + ' Zone' as CombineStatement from Region Order by 1",null,null,"Combine_With_OrderBy"]
["Provide the count of Price by considering group by Item from Sales table",null,null,"Select Item, Count(Price) as GroupByPrice from Sales Group By Item",null,null,"GroupByPrice"]

{"sheet":"DataBase","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,8,1,9]]}
[]
[null,null,null,"Sales",null,null,null,null,"Region"]
[]
[null,null,null,"Item","Price","Quantity",null,null,"Item","Location","Dates"]
[null,null,null,"Apple",150,2400,null,null,"Apple","North","2020-01-27"]
[null,null,null,"Banana",145,3600,null,null,"Banana","East","2020-01-28"]
[null,null,null,"Orange",135,2400,null,null,"Guava","South","2020-12-30"]
[null,null,null,"Grapes",85,3540,null,null,"Grapes","South","2021-01-27"]
[null,null,null,"PineApple",86,950,null,null,"Watermelon","East","2020-12-31"]