{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Introduction","DataSheet"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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,"ADODB Connection \n- \nExcel as Database"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"DataSheet","index":1,"n_rows":120,"n_cols":15,"rows_kept":120,"cut":false,"hidden":false,"merged":[[15,7,16,9],[15,11,16,12],[15,14,16,15],[1,1,1,2],[15,0,16,1],[15,5,16,5],[1,7,1,8],[2,11,2,13],[1,11,1,14]]}
[]
[null,"Sales Table",null,null,null,null,null,"Users Table",null,null,null,"Template Last Updated"]
[null,null,null,null,null,null,null,null,null,null,null,"2018-02-21"]
[null,"Item","Price","Quantity","Dates",null,null,"Item","User"]
[null,"Pen",150,2400,"2016-01-15",null,null,"Pen","Authors"]
[null,"Pencil",145,3600,"2017-12-31",null,null,"Pencil","Designers"]
[null,"Eraser",135,2400,"2016-06-30",null,null,"Marker","Designers"]
[null,"Marker",85,3540,"2017-04-24"]
[null,"Boards",86,950,"2016-12-31",null,null,null,null,null,null,null,"Total Examples"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A19:A142)","v":101}]
[]
[]
[]
[]
["Query",null,null,null,null,"Syntax",null,"Sheet Name",null,null,null,"Header",null,null,"HyperLink"]
[]
[null,null,null,null," ",null,null," ",null," "]
["Select all columns from sales table",null,null,null," ","Select * FROM [Sales]",null," ","Star"," ",null,"Item,Price,Quantity,Dates"]
["Select Item Column from Sales table",null,null,null," ","Select Item FROM [Users]",null," ","Column_Item"," ",null,"Item"]
["Select Item Column Where   Price > 100 from Sales table",null,null,null," ","Select Item FROM [Users]",null," ","Price_Greaterthan_100"," ",null,"Item"]
["Select Price Column Where   Price < 100 from Sales table",null,null,null," ","Select Price FROM [Sales] where Price < 100",null," ","Price_Lessthan_100"," ",null,"Price"]
["Order by sales table by ITEM",null,null,null," ","Select * FROM [Sales] order by Item",null," ","OrderByItem"," ",null,"Item,Price,Quantity,Dates"]
["Order by sales table by PRICE",null,null,null," ","Select * FROM [Sales] order by Price",null," ","OrderByPrice"," ",null,"Item,Price,Quantity,Dates"]
["Order by Sales Table by first column",null,null,null," ","Select * FROM [Sales] order by 1",null," ","OrderbyFirstcolumn"," ",null,"Item,Price,Quantity,Dates"]
["Order by Sales Table by second column",null,null,null," ","Select * FROM [Sales] order by 2",null," ","OrderbySecondColumn"," ",null,"Item,Price,Quantity,Dates"]
["Order by Item column in Sales Table by Descending",null,null,null," ","Select Item FROM [Sales] order by Item desc",null," ","Item_Desc"," ",null,"Item"]
["Order by Price column in Sales Table by Ascending",null,null,null," ","Select Price FROM [Sales] order by Price Asc",null," ","Price_Asc"," ",null,"Price"]
["Retrieve records from sales table, where price equal to  90 and   145",null,null,null," ","Select * from Sales where Price >=90 and Price<=145",null," ","AND_Operator_Price"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve Item records from sales table, where Items represents to Pen and Eraser",null,null,null," ","Select * from Sales where Item='Pen' or Item='Eraser'",null," ","OR_Operator_Item"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve records from sales table, where price >=  85 and <=145",null,null,null," ","Select * from Sales where Price  between  85 and  145",null," ","Between_Operator_Price"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve records from sales table, where price >=  85 and <=145 Order by Quantity",null,null,null," ","Select * from Sales where Price  between  85 and  145 Order by Quantity",null," ","Between_OrderbyQTY"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve records from sales table, where price not in the range of   85 and  145",null,null,null," ","Select * from Sales where Price  not between  85 and  145",null," ","Not_Between_Operator_Price"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve records from sales table, where Items represents to PEN,PENCIL,MARKER",null,null,null," ","Select * from Sales where Item in('Pen','Pencil','Marker')",null," ","In_Operator_Item"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve records from sales table, where Items doesn't represents to PEN,PENCIL,MARKER",null,null,null," ","Select * from Sales where Item not in('Pen','Pencil','Marker')",null," ","Not_In_Operator_Item"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve records from sales table, where Price having NULL value",null,null,null," ","Select * from Sales where Price IS Null",null," ","IS_Null_Of_Price"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve records from sales table, where Price having Not NULL value",null,null,null," ","Select * from Sales where Price IS Not Null",null," ","IS_Not_Null"," ",null,"Item,Price,Quantity,Dates"]
["Retrieve Length of Item records from sales table",null,null,null," ","Select Item, len(Item) as Length FROM [Sales]",null," ","Len_Function"," ",null,"Item,Length"]
["Retrieve Item records where Length having >5 from sales table",null,null,null," ","Select Item, len(Item) as Length FROM [Sales] where Len(Item)>5",null," ","Len_Greaterthan_5"," ",null,"Item,Len>5"]
["Retrieve Item records where Length is < 5 from sales table",null,null,null," ","Select Item, len(Item) as Length FROM [Sales] where Len(Item)<5",null," ","Len_Lessthan_5"," ",null,"Item,Len<5"]
["Retrieve Item records where Length is >=5 and <=8 from sales table",null,null,null," ","Select Item, len(Item) as Length FROM [Sales] where Len(Item)>=5 and Len(Item)<=8",null," ","Len_Greater_Less_5_8"," ",null,"Item,Len>=5and<=8"]
["Select Item Column where Item starts with P from Sales table",null,null,null," ","Select Item FROM [Sales] where left(Item,1) = 'P'",null," ","Item_Starts_with_p"," ",null,"Item"]
["Select Item and Price Columns where Item ends with \"R\" from Sales table",null,null,null," ","Select * FROM [Sales] where Right(Item,1) = 'r'",null," ","Item_Ends_with_r"," ",null,"Item,Price,Quantity,Dates"]
["Select Max Price from sales table",null,null,null," ","Select Max(Price)  as MaxPrice from  [Sales]",null," ","Max_Price"," ",null,"MaxPrice"]
["Select Min Price from sales table",null,null,null," ","Select Min(Price)  as MinPrice from  [Sales]",null," ","Min_Price"," ",null,"MinPrice"]
["Select Min Price among Pencil and Eraser from sales table",null,null,null," ","Select Min(Price)  as MinPrice from  [Sales] where Item in( 'Pencil','Eraser' )",null," ","Min_Price_Two_Items"," ",null,"MinPrice"]
["Sum the Price of Items where Item starts with \"P\" from sales table",null,null,null," ","Select Sum(Price)  as SumPrice from  [Sales] where left(Item,1)='p'",null," ","SumOfITemsStartswithP"," ",null,"SumPrice"]
["Sum the QUANTITY of Items where Item Ends with \"R\" from sales table",null,null,null," ","Select Sum(Quantity)  as SumPrice from  [Sales] where Right(Item,1)='r'",null," ","SumOfITemsEndswithP"," ",null,"SumPrice"]
["Sum the QUANTITY of Items where Price > 100 from sales table",null,null,null," ","Select Sum(Quantity)  as SumPrice from  [Sales] where  Price > 100",null," ","SumQTYGreaterthan100"," ",null,"SumQuantity>100"]
["Calculate Total Cost of Boards from sales table",null,null,null," ","Select Item, Price, Quantity,Quantity*Price as TotalCost from Sales where Item = 'Boards' ",null," ","SumOfBoards"," ",null,"Item,Price,Quantity,TotalCost"]
["Calculate total cost of items having price greater than 100 from sales table",null,null,null," ","Select Item, Price, Quantity,Quantity*Price as TotalCost from Sales where Price > 100",null," ","SumItemsonPrice"," ",null,"Item,Price,Quantity,TotalCost"]
["Calculate total cost of items having Quantity Less than 2000  from sales table",null,null,null," ","Select Item, Price, Quantity,Quantity*Price as TotalCost from Sales where Quantity < 2000",null," ","SumItemsonQuanity"," ",null,"Item,Price,Quantity,TotalCost"]
["Count Items from Sales table",null,null,null," ","Select count(Item) as ItemsCount from [Sales]",null," ","Items_Count"," ",null,"Items Count"]
["Count Items from Sales table where letter starts with M",null,null,null," ","Select count(Item) as ItemsCount from [Sales] where left(Item, 1) = 'M'",null," ","Items_Count_startswith_M"," ",null,"Items Count"]
["Count Items from Sales table where Quantity greaterthan 3000",null,null,null," ","Select count(Item) as ItemsCount from [Sales] where Quantity > 3000",null," ","Items_Quanity_Greaterthan"," ",null,"ItemsCount"]
["Top 3 records based on Price from sales table",null,null,null," ","Select Top 3 Price from [Sales]",null," ","Top_Three_Pricing"," ",null,"Top_Three"]
["Top 2 records based on Quantity from sales table",null,null,null," ","Select Top 2 Quantity from [Sales]",null," ","Top_Two_Quantity"," ",null,"Top_Two_Quantity"]
["Select Top 2 Price, Quantity records from sales table",null,null,null," ","Select Top 2 Price, Quantity  from [Sales]",null," ","Top_Two_Price_Quantity"," ",null,"Price,Quantity,Item"]
["Select Top 2  Quantity, Price, Item records from sales table",null,null,null," ","Select Top 2 Quantity, Price , Item from [Sales]",null," ","Top_Two_Quantity_Price"," ",null,"Quantity, Price,Item"]
["Select Top 4 of  Quantity, Price, Item records from sales table Order by Price",null,null,null," ","Select Top 4 Quantity, Price, Item from [Sales] Order by Price",null," ","Top_Four_Orderby_Price"," ",null,"Quantity, Price,Item"]
["Select Top 4 of  Quantity, Price, Item records from sales table Order by Quantity",null,null,null," ","Select Top 4 Quantity, Price, Item from [Sales] Order by Quantity",null," ","Top_Four_Orderby_Qty"," ",null,"Quantity, Price,Item"]
["Select Top 4 of  Quantity, Price, Item records from sales table where Quantity greater than 2000",null,null,null," ","Select Top 4 Quantity, Price, Item from [Sales] where Quantity > 2000 Order by Quantity",null," ","Qty_In_ASC_Price_In_Desc"," ",null,"Quantity, Price,Item"]
["Select Top 4 of  Quantity, Price, Item records from sales table where Quantity greater than 3000",null,null,null," ","Select Top 4 Quantity, Price, Item from [Sales] where Quantity > 3000 Order by Quantity",null," ","TopFour_Threethousand"," ",null,"Quantity, Price,Item"]
["Select Top 4 records of Price,Item order by Pricing from sales table",null,null,null," ","Select Top 4   Price, Item from [Sales] Order by Price desc",null," ","TOP_Three_Desc"," ",null,"Item,Price"]
["Retrive records where Item starts with \"B\" from sales table",null,null,null," ","Select Item,Price,Quantity,Dates from Sales where Item like 'B%'",null," ","Item_Starts_with_B"," ",null,"Item,Price,Quantity,Dates"]
["Retrive records where Item starts with \"P\" or \"B\" Order by  Price  in Asc  from sales table",null,null,null," ","Select Item,Price,Quantity,Dates from Sales where Item like 'P%' or Item like 'B%' Order by Price",null," ","Item_Starts_with_B_P"," ",null,"Item,Price,Quantity,Dates"]
["Retrive records where Item starts with \"P\" or Price is less than 100 and Quantity between 2400 to 3000 from sales table",null,null,null," ","Select * from Sales where(Item like 'P%' or Price < 100 or Quantity between 2300 and 2500)",null," ","ItemPriceQty_OR"," ",null,"Item,Price,Quantity,Dates"]
["Retrive records where Item starts with \"P\" or Quantity between 2400 to 3000 from sales table",null,null,null," ","Select * from Sales where(Item like 'P%' or   Quantity between 2300 and 2500)",null," ","Item_Quantity"," ",null,"Item,Price,Quantity,Dates"]
["select all columns from Users table",null,null,null," ","Select * from Users",null," ","Users_Star",null,null,"Item,User"]
["select Item column Users table",null,null,null," ","Select Item from Users",null," ","Users_Item",null,null,"Item"]
["Remove duplicates from User column from Users table",null,null,null," ","Select Distinct User from Users",null," ","User_remove_dup",null,null,"User"]
["Retrieve records which Item starts with \"P\" and User doesn’t belongs to AUTHORS from Users table",null,null,null," ","Select * from Users where Item like \"P%\" and User <> 'Authors'",null," ","Item_User_Like",null,null,"Item,User"]
["Add 5 Days to the Dates Column from sales table",null,null,null," ","Select Dates, Dates + 5 as Daysadded from sales",null," ","Add_Days",null,null,"Dates, Daysadded"]
["Deduct 5 Days from the Dates Column from sales table",null,null,null," ","Select Dates, Dates - 5 as 5daysdeducted from sales",null," ","Deduct_Days",null,null,"Dates,5Daysdeducted"]
["Select all columns from sales table Orderby date",null,null,null," ","Select * from sales Order by Dates",null," ","Order_by_Date",null,null,"Item,Price,Quantity,Dates"]
["Select all columns from sales table Orderby date in descending",null,null,null," ","Select * from sales Order by Dates Desc",null," ","Order_by_Date_Desc",null,null,"Item,Price,Quantity,Dates"]
["Order the Sales table by length of Item column",null,null,null," ","Select * from sales Order by  len(Item) Desc",null," ","OrderbyLenItem",null,null,"Item,Price,Quantity,Dates"]
["Retrieve Dates, Years of dates from sales table",null,null,null," ","Select Dates, year(Dates) as Years from sales",null," ","Years_of_Date",null,null,"Dates,Years"]
["Retrieve Item records where Year = 2017 from sales table",null,null,null," ","Select Item,Dates, year(Dates) as Years from sales where Year(Dates) = 2017",null," ","YearofDateequals",null,null,"Item,Date,Years"]
["Retrieve Item records where Year = 2016 from sales table",null,null,null," ","Select Item,Dates, year(Dates) as Years from sales where Year(Dates) = 2016",null," ","YearOfdateEQual",null,null,"Item,Date,Years"]
["Retrieve Dates, Month of dates from sales table",null,null,null," ","Select Dates, Month(Dates) as Months from sales",null," ","Retrieve_Month",null,null,"Dates,Months"]
["Retrieve Items,Dates, Month of dates from sales table where month is less than June",null,null,null," ","Select Item,Dates, month(Dates) as Years from sales where month(Dates) <  6",null," ","Month_Range",null,null,"Items,Dates,Months"]
["Retrieve Items,Dates, Date of dates from sales table ",null,null,null," ","Select Item,Dates, day(Dates) as DatesDate from sales",null," ","Date_Dates",null,null,"Items,Dates,DatesDate"]
["Provide Inner Join between Sales table and Users table",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item",null," ","InnerJoin_twotables",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Provide Inner Join between Sales table and Users table Order by Price",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item Order by Price",null," ","InnerJoin_Orderby_Price",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records of 2016 by providing  Inner Join between Sales table and Users table  ",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item  where year(Dates) = 2016",null," ","InnerJoin_By_Year",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records of designer by providing  Inner Join between Sales table and Users table  ",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item  where User = 'Designers'",null," ","InnerJoin_Of_Designer",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Inner Join between Sales table and Users table  where Quantity between 3000 and 4000",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item  where sales.Quantity between 3000 and 4000",null," ","InnerJoin_Quantity_Between",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Inner Join between Sales table and Users table    where ITem starts with \"P\"",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item  where sales.Item like 'P%'",null," ","InnerJoin_Itemwith_P",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Inner Join between Sales table and Users table    where User starts with \"D\"",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item  where Users.User like 'D%'",null," ","InnerJoin_Userends_with_D",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Inner Join between Sales table and Users table  where Item of sales table starts with \"P\" or   User of Users table ends with S",null,null,null," ","select * from sales inner join Users on sales.Item = Users.Item  where sales.Item like 'p%' or Users.User like '%S'",null," ","Innerjoin_Item_User",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve Item,Price,User records from Sales and Users table by providing Inner Join",null,null,null," ","select sales.Item, sales.Price, Users.User from sales inner join Users on sales.Item = Users.Item",null," ","Innerjoin_Item_Price_User",null,null,"Items,Price,User"]
["Retrieve Item,Price,User records from Sales and Users table by providing Inner Join where Price > 100",null,null,null," ","select sales.Item, sales.Price, Users.User from sales inner join Users on sales.Item = Users.Item where sales.Price > 100",null," ","Innerjoin_Price_Greaterthan",null,null,"Items,Price,User"]
["Retrieve User from Users table where Quantity is greater than 3000 of Sales Table",null,null,null," ","select sales.Quantity,  Users.User from sales inner join Users on sales.Item = Users.Item where sales.Quantity > 3000",null," ","Innerjoin_QuantityGreater",null,null,"Quantity,User"]
["Provide Left Outer join between Sales table and Users table",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item",null," ","LeftOuter_twotables",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Provide Left Outer join between Sales table and Users table Order by Price",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item Order by Sales.Price",null," ","LeftOuter_Orderby_Price",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records of 2016 by providing  Left Outer join between Sales table and Users table  ",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item  where year(Dates) = 2016",null," ","LeftOuter_By_Year",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records of designer by providing  Left Outer join between Sales table and Users table  ",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item  where User = 'Designers'",null," ","LeftOuter_Of_Designer",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Left Outer join between Sales table and Users table  where Quantity between 3000 and 4000",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item  where sales.Quantity between 3000 and 4000",null," ","LeftOuter_Quantity_Between",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Left Outer join between Sales table and Users table    where ITem starts with \"P\"",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item  where sales.Item like 'P%'",null," ","LeftOuter_Itemwith_P",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Left Outer join between Sales table and Users table    where User starts with \"D\"",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item  where Users.User like 'D%'",null," ","LeftOuter_Userends_with_D",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Left Outer join between Sales table and Users table  where Item of sales table starts with \"P\" or   User of Users table ends with S",null,null,null," ","select * from sales Left Outer join Users on sales.Item = Users.Item  where sales.Item like 'p%' or Users.User like '%S'",null," ","LeftOuter_Item_User",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve Item,Price,User records from Sales and Users table by providing Left Outer join",null,null,null," ","select sales.Item, sales.Price, Users.User from sales Left Outer join Users on sales.Item = Users.Item",null," ","LeftOuter_Item_Price_User",null,null,"Items,Price,User"]
["Retrieve Item,Price,User records from Sales and Users table by providing Left Outer join where Price > 100",null,null,null," ","select sales.Item, sales.Price, Users.User from sales Left Outer join Users on sales.Item = Users.Item where sales.Price > 100",null," ","LeftOuter_Price_Greaterthan",null,null,"Items,Price,User"]
["Retrieve User from Users table where Quantity is greater than 3000 of Sales Table",null,null,null," ","select sales.Quantity,  Users.User from sales Left Outer join Users on sales.Item = Users.Item where sales.Quantity > 3000",null," ","LeftOuter_QuantityGreater",null,null,"Quantity,User"]
["Provide Right Outer Join between Sales table and Users table",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item",null," ","RightOuter_twotables",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Provide Right Outer Join between Sales table and Users table Order by Price",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item Order by Sales.Price",null," ","RightOuter_Orderby_Price",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records of 2016 by providing  Right Outer Join between Sales table and Users table  ",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item  where year(Dates) = 2016",null," ","RightOuter_By_Year",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records of designer by providing  Right Outer Join between Sales table and Users table  ",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item  where User = 'Designers'",null," ","RightOuter_Of_Designer",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Users table  where Quantity between 3000 and 4000",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item  where sales.Quantity between 3000 and 4000",null," ","RightOuter_Quantity_Between",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Users table    where ITem starts with \"P\"",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item  where sales.Item like 'P%'",null," ","RightOuter_Itemwith_P",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Users table    where User starts with \"D\"",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item  where Users.User like 'D%'",null," ","RightOuter_Userends_with_D",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Users table  where Item of sales table starts with \"P\" or   User of Users table ends with S",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item  where sales.Item like 'p%' or Users.User like '%S'",null," ","RightOuter_Item_User",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve Item,Price,User records from Sales and Users table by providing Right Outer Join",null,null,null," ","select sales.Item, sales.Price, Users.User from sales Right Outer Join Users on sales.Item = Users.Item",null," ","RightOuter_Item_Price_User",null,null,"Items,Price,User"]
["Retrieve Item,Price,User records from Sales and Users table by providing Right Outer Join where Price > 100",null,null,null," ","select sales.Item, sales.Price, Users.User from sales Right Outer Join Users on sales.Item = Users.Item where sales.Price > 100",null," ","RightOuter_Price_Greaterthan",null,null,"Items,Price,User"]
["Retrieve User from Users table where Quantity is greater than 3000 of Sales Table",null,null,null," ","select sales.Quantity,  Users.User from sales Right Outer Join Users on sales.Item = Users.Item where sales.Quantity > 3000",null," ","RightOuter_QuantityGreater",null,null,"Quantity,User"]
["Retrieve all records  by providing  Right Outer Join between Sales table and Users table    where Quantity is less than 2000",null,null,null," ","select * from sales Right Outer Join Users on sales.Item = Users.Item  where Sales.Quantity < 2000",null," ","RightOuter_Quantity",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Left Outer Join between Sales table and Users table    where Quantity is less than 2000",null,null,null," ","select * from sales Left Outer Join Users on sales.Item = Users.Item  where Sales.Quantity < 2000",null," ","LeftOuter_Quantity",null,null,"Items,Price,Quantity,Dates,Item,User"]
["Retrieve all records  by providing  Inner Join between Sales table and Users table    where Quantity is less than 2000",null,null,null," ","select * from sales Inner  Join Users on sales.Item = Users.Item  where Sales.Quantity < 2000",null," ","InnerJoin_Quantity",null,null,"Items,Price,Quantity,Dates,Item,User"]
[null,null,null,null," ",null,null," "]