function FileData_Pairs(x)
{
x.t("statements","extensions");
x.t("statements","default");
x.t("statements","single");
x.t("statements","select");
x.t("statements","duplicates");
x.t("statements","intersect");
x.t("extensions","salesforce");
x.t("example","min");
x.t("example","example");
x.t("example","uses");
x.t("example","sort");
x.t("example","count");
x.t("example","distinct");
x.t("example","assign");
x.t("example","sum");
x.t("example","limit");
x.t("example","display");
x.t("example","select");
x.t("example","number");
x.t("example","max");
x.t("example","specifies");
x.t("example","salary");
x.t("example","previous");
x.t("example","last_name");
x.t("example","avg");
x.t("example","totals");
x.t("example","valid");
x.t("example","table_alias");
x.t("example","two");
x.t("example","following");
x.t("example","returns");
x.t("complex","expressions");
x.t("complex","column");
x.t("min","minimum");
x.t("min","max");
x.t("min","(salary)");
x.t("equal","sign");
x.t("included","result");
x.t("columns","results");
x.t("columns","specified");
x.t("columns","returned");
x.t("columns","values");
x.t("columns","grammar");
x.t("o.ownerid","u.id");
x.t("fetch","results");
x.t("$200,000","having");
x.t("$200,000","select");
x.t("$200,000","clause");
x.t("right","outer");
x.t("right","select");
x.t("taking","results");
x.t("counted","default");
x.t("lists","supported");
x.t("lists","select");
x.t("within","select");
x.t("meet","retrieved");
x.t("relational","operator");
x.t("offset_number","number");
x.t("offset_number","number_of_rows");
x.t("applied","entire");
x.t("select_statement","distinct");
x.t("select_statement","union");
x.t("select_statement","orderby_clause");
x.t("select_statement","intersect");
x.t("select_statement","except");
x.t("select_statement","using");
x.t("[as]","column_alias");
x.t("table","table");
x.t("table","alias");
x.t("table","cached");
x.t("table","emp");
x.t("table","prefix");
x.t("table","name");
x.t("table","references");
x.t("table","aggregate");
x.t("table","rest");
x.t("table","aliases");
x.t("table","named");
x.t("table","subquery");
x.t("table","10-3");
x.t("table","names");
x.t("refer","table");
x.t("having","expr1");
x.t("having","sum");
x.t("having","clause");
x.t("asterisk","retrieve");
x.t("alias","example");
x.t("alias","table");
x.t("alias","department");
x.t("alias","sql");
x.t("cross","join");
x.t("tables","within");
x.t("tables","multiple");
x.t("tables","joined");
x.t("tables","select");
x.t("tables","combination");
x.t("tables","define");
x.t("tables","clauses");
x.t("tables","used");
x.t("creates","new");
x.t("creates","temporary");
x.t("creates","result");
x.t("user","o.ownerid");
x.t("remote","tables");
x.t("last","name");
x.t("last","names");
x.t("uses","count");
x.t("restated","explicit");
x.t("expr1","expr2");
x.t("expr1","either");
x.t("expr1","rel_operator");
x.t("statement","included");
x.t("statement","fetch");
x.t("statement","limit");
x.t("statement","retrieves");
x.t("statement","first");
x.t("statement","number");
x.t("statement","expressions");
x.t("statement","attached");
x.t("statement","removing");
x.t("statement","joins");
x.t("statement","operate");
x.t("statement","except");
x.t("statement","returns");
x.t("statement","grammar");
x.t("statement","specify");
x.t("expr2","expr1");
x.t("expr2","column");
x.t("expr2","either");
x.t("type","count");
x.t("type","select");
x.t("type","last_name");
x.t("type","column");
x.t("avgamount","opportunity");
x.t("200000","union");
x.t("left","right");
x.t("left","outer");
x.t("left","select");
x.t("non-null","column");
x.t("bound","number");
x.t("bound","offset");
x.t("identify","columns");
x.t("multiple","table");
x.t("multiple","tables");
x.t("multiple","values");
x.t("multiple","column");
x.t("precede","first");
x.t("cached","memory");
x.t("total","values");
x.t("ascending","asc");
x.t("sort","example");
x.t("sort","last_name");
x.t("new_table","limit");
x.t("new_table","disk");
x.t("dep","emp");
x.t("dep","e.deptid");
x.t("dep","select");
x.t("dep","subqueries");
x.t("dep","department");
x.t("default","duplicate");
x.t("default","perform");
x.t("default","behavior");
x.t("count","(amount)");
x.t("count","distinct");
x.t("count","aggregate");
x.t("count","number");
x.t("count","max");
x.t("count","column");
x.t("count","integer");
x.t("count","(name)");
x.t("count","returns");
x.t("(amount)","avgamount");
x.t("(amount)","numopportunities");
x.t("(amount)","maxamount");
x.t("comma","example");
x.t("comma","column_expression");
x.t("distinct","last");
x.t("distinct","dep");
x.t("distinct","default");
x.t("distinct","minus");
x.t("distinct","last_name");
x.t("distinct","department");
x.t("distinct","values");
x.t("distinct","column_expression");
x.t("distinct","operator");
x.t("single","value");
x.t("single","result");
x.t("want","retrieve");
x.t("details","multiple");
x.t("details","regarding");
x.t("details","expressions");
x.t("details","column_expression");
x.t("details","column_alias");
x.t("emp","dep");
x.t("emp","distinct");
x.t("emp","group");
x.t("emp","union");
x.t("emp","inner");
x.t("emp","different");
x.t("emp","salary");
x.t("emp","null");
x.t("emp","sal");
x.t("emp","separate");
x.t("emp","intersect");
x.t("emp","order");
x.t("emp","except");
x.t("new","table");
x.t("among","tables");
x.t("prefix","column");
x.t("retrieved","grammar");
x.t("top","number");
x.t("e.last_name","alias");
x.t("o.isclosed","false");
x.t("includes","nonmatching");
x.t("includes","matching");
x.t("combines","results");
x.t("synonymous","operators");
x.t("synonymous","optional");
x.t("places","upper");
x.t("upper","bound");
x.t("list","example");
x.t("list","column");
x.t("list","order");
x.t("list","sql");
x.t("u.id","o.isclosed");
x.t("indicates","tables");
x.t("indicates","upper");
x.t("having_clause","union");
x.t("having_clause","optional");
x.t("complete","explanation");
x.t("complete","information");
x.t("group","column_expression");
x.t("group","clause");
x.t("group","dept_id");
x.t("assign","alias");
x.t("treated","distinct");
x.t("sum","total");
x.t("sum","salaries");
x.t("sum","salary");
x.t("sum","(salary)");
x.t("numopportunities","max");
x.t("joined","using");
x.t("t2.key","cross");
x.t("dept.deptno","information");
x.t("beginning","result");
x.t("results","right");
x.t("results","tables");
x.t("results","left");
x.t("results","returned");
x.t("results","join");
x.t("results","two");
x.t("results","aggregated");
x.t("results","using");
x.t("20000","group");
x.t("20000","order");
x.t("unless","distinct");
x.t("duplicate","rows");
x.t("duplicate","values");
x.t("false","u.name");
x.t("specified","select");
x.t("specified","number");
x.t("specified","offset");
x.t("specified","order");
x.t("commas","example");
x.t("union","distinct");
x.t("union","select");
x.t("union","optional");
x.t("union","operator");
x.t("union","grammar");
x.t("name","example");
x.t("name","table");
x.t("name","count");
x.t("name","literal");
x.t("name","match");
x.t("name","pay");
x.t("name","values");
x.t("name","column");
x.t("name","used");
x.t("name","sql");
x.t("enclosed","parentheses");
x.t("dept","new_emp.deptno");
x.t("nonmatching","rows");
x.t("references","table_name");
x.t("limit","applied");
x.t("limit","number");
x.t("limit","number_of_rows");
x.t("limit","offset");
x.t("limit","clause");
x.t("aggregate","functions");
x.t("aggregate","expression");
x.t("aggregate","values");
x.t("aggregate","used");
x.t("aggregate","returns");
x.t("eliminates","duplicate");
x.t("average","salary");
x.t("average","values");
x.t("raises","example");
x.t("raises","intersect");
x.t("raises","order");
x.t("raises","except");
x.t("perform","ascending");
x.t("skip","beginning");
x.t("skip","compound");
x.t("from_clause","where_clause");
x.t("from_clause","specifies");
x.t("inner","left");
x.t("inner","join");
x.t("table_name","example");
x.t("table_name","right");
x.t("table_name","name");
x.t("table_name","table_alias");
x.t("manipulation","example");
x.t("opportunity","inner");
x.t("sign","includes");
x.t("place","table");
x.t("compound","query");
x.t("allows","query");
x.t("exclude","null");
x.t("rest","select");
x.t("search-condition","example");
x.t("$20,000","select");
x.t("final","select");
x.t("local","remote");
x.t("string","manipulation");
x.t("prefixed","table");
x.t("copies","result");
x.t("regarding","sql");
x.t("entire","query");
x.t("minus","synonymous");
x.t("minus","operators");
x.t("minus","[distinct]");
x.t("second","example");
x.t("second","item");
x.t("functions","table");
x.t("functions","details");
x.t("functions","aggregate");
x.t("functions","exclude");
x.t("functions","select");
x.t("functions","return");
x.t("functions","result");
x.t("e.deptid","d.id");
x.t("retrieves","first");
x.t("display","departments");
x.t("equivalent","limit");
x.t("mathematical","operations");
x.t("supported","aggregate");
x.t("maxamount","avg");
x.t("where_clause","groupby_clause");
x.t("where_clause","optional");
x.t("explanation","having_clause");
x.t("explanation","union");
x.t("explanation","from_clause");
x.t("explanation","where_clause");
x.t("explanation","select");
x.t("explanation","groupby_clause");
x.t("explanation","orderby_clause");
x.t("explanation","intersect");
x.t("explanation","except");
x.t("explanation","limit_clause");
x.t("keeping","distinct");
x.t("operators","complete");
x.t("operators","select");
x.t("operators","return");
x.t("operators","except");
x.t("operators","returns");
x.t("disk","creates");
x.t("disk","temp");
x.t("give","column");
x.t("outer","cross");
x.t("outer","inner");
x.t("outer","join");
x.t("select","statements");
x.t("select","lists");
x.t("select","statement");
x.t("select","left");
x.t("select","dep");
x.t("select","count");
x.t("select","distinct");
x.t("select","emp");
x.t("select","list");
x.t("select","name");
x.t("select","limit");
x.t("select","select");
x.t("select","salary");
x.t("select","last_name");
x.t("select","e.name");
x.t("select","emp_id");
x.t("select","select_clause");
x.t("select","emp.last_name");
x.t("select","clause");
x.t("select","dept_id");
x.t("select","sql");
x.t("first","table");
x.t("first","last");
x.t("first","number");
x.t("first","discards");
x.t("first","column");
x.t("first","offset");
x.t("preceded","distinct");
x.t("minimum","salary");
x.t("minimum","value");
x.t("t1.key","t2.key");
x.t("allowed","join");
x.t("number","example");
x.t("number","creates");
x.t("number","non-null");
x.t("number","distinct");
x.t("number","top");
x.t("number","indicates");
x.t("number","name");
x.t("number","equivalent");
x.t("number","rows");
x.t("number","discard");
x.t("number","values");
x.t("number","column_expression");
x.t("number","column");
x.t("number","remaining");
x.t("10000","new_emp");
x.t("literal","expression");
x.t("retrieve","asterisk");
x.t("retrieve","value");
x.t("max","(amount)");
x.t("max","maximum");
x.t("max","avg");
x.t("max","(salary)");
x.t("maximum","number");
x.t("maximum","rows");
x.t("maximum","salary");
x.t("maximum","value");
x.t("aliases","emp");
x.t("combination","complex");
x.t("combination","grammar");
x.t("specifies","columns");
x.t("specifies","tables");
x.t("specifies","maximum");
x.t("specifies","rows");
x.t("specifies","two");
x.t("specifies","names");
x.t("specifies","conditions");
x.t("departments","salaries");
x.t("expressions","example");
x.t("expressions","identify");
x.t("expressions","default");
x.t("expressions","details");
x.t("expressions","commas");
x.t("expressions","select");
x.t("expressions","may");
x.t("expressions","expressions");
x.t("expressions","different");
x.t("expressions","match");
x.t("expressions","data");
x.t("expressions","column");
x.t("expressions","order");
x.t("expressions","sql");
x.t("expressions","rel_operator");
x.t("may","include");
x.t("may","either");
x.t("define","implicit");
x.t("d.id","equal");
x.t("d.id","grammar");
x.t("person","example");
x.t("different","salary");
x.t("different","data");
x.t("salaries","totaling");
x.t("salaries","department");
x.t("salaries","employees");
x.t("first_name","emp");
x.t("first_name","limit");
x.t("first_name","select");
x.t("first_name","hire_date");
x.t("first_name","either");
x.t("instead","table");
x.t("row","distinct");
x.t("row","contains");
x.t("returned","unless");
x.t("returned","select");
x.t("returned","rows");
x.t("returned","return");
x.t("returned","made");
x.t("returned","value");
x.t("returned","query");
x.t("returned","result");
x.t("returned","values");
x.t("keyword","union");
x.t("keyword","clause");
x.t("section","restated");
x.t("match","column");
x.t("types","specified");
x.t("types","column");
x.t("simply","column");
x.t("explicit","count");
x.t("explicit","inner");
x.t("explicit","keyword");
x.t("explicit","implicit");
x.t("grouped","clause");
x.t("added","grammar");
x.t("salesforce","driver");
x.t("rows","example");
x.t("rows","meet");
x.t("rows","left");
x.t("rows","results");
x.t("rows","specified");
x.t("rows","aggregate");
x.t("rows","skip");
x.t("rows","select");
x.t("rows","returned");
x.t("rows","keyword");
x.t("rows","return");
x.t("rows","sorted");
x.t("rows","null");
x.t("rows","result");
x.t("rows","including");
x.t("rows","specify");
x.t("groups","group");
x.t("groups","rows");
x.t("return","single");
x.t("return","duplicate");
x.t("return","aggregate");
x.t("return","rows");
x.t("return","remaining");
x.t("salary","emp");
x.t("salary","20000");
x.t("salary","last_name");
x.t("salary","hire_date");
x.t("salary","1.05");
x.t("salary","1.07");
x.t("salary","column");
x.t("memory","temp");
x.t("previous","section");
x.t("least","$20,000");
x.t("sorted","grammar");
x.t("appear","final");
x.t("[distinct]","select_statement");
x.t("[distinct]","minus");
x.t("[distinct]","select");
x.t("[distinct]","intersect");
x.t("[distinct]","except");
x.t("totaling","$200,000");
x.t("parentheses","subqueries");
x.t("parentheses","subquery");
x.t("null","values");
x.t("made","explicit");
x.t("groupby_clause","having_clause");
x.t("groupby_clause","optional");
x.t("last_name","complex");
x.t("last_name","example");
x.t("last_name","raises");
x.t("last_name","second");
x.t("last_name","first_name");
x.t("last_name","salary");
x.t("include","aggregate");
x.t("include","mathematical");
x.t("include","non-aggregate");
x.t("subqueries","complete");
x.t("subqueries","enclosed");
x.t("subqueries","subqueries");
x.t("subqueries","used");
x.t("subqueries","clause");
x.t("subqueries","rel_operator");
x.t("e.name","d.deptname");
x.t("sal","10000");
x.t("value","min");
x.t("value","columns");
x.t("value","type");
x.t("value","sum");
x.t("value","rows");
x.t("value","column");
x.t("discards","first");
x.t("hire_date","emp");
x.t("hire_date","column");
x.t("named","includes");
x.t("avg","type");
x.t("avg","(amount)");
x.t("avg","average");
x.t("avg","aggregate");
x.t("avg","salary");
x.t("avg","(salary)");
x.t("already","defined");
x.t("constant","values");
x.t("pay","birth_date");
x.t("emp_id","last_name");
x.t("orderby_clause","optional");
x.t("orderby_clause","limit_clause");
x.t("sorts","results");
x.t("sorts","last_name");
x.t("temporary","table");
x.t("myname","clause");
x.t("totals","salaries");
x.t("number_of_rows","specifies");
x.t("number_of_rows","offset");
x.t("select_clause","from_clause");
x.t("select_clause","specifies");
x.t("clauses","query");
x.t("1.05","sql");
x.t("department","having");
x.t("department","emp");
x.t("department","sum");
x.t("department","select");
x.t("department","row");
x.t("department","column");
x.t("emp.last_name","e.last_name");
x.t("expression","example");
x.t("expression","table");
x.t("expression","expr2");
x.t("expression","preceded");
x.t("expression","allowed");
x.t("expression","select");
x.t("expression","subquery");
x.t("expression","positioned");
x.t("expression","order");
x.t("expression","operator");
x.t("expression","sql");
x.t("subquery","multiple");
x.t("subquery","subqueries");
x.t("subquery","clause");
x.t("valid","already");
x.t("valid","data");
x.t("separate","multiple");
x.t("10-3","lists");
x.t("10-3","aggregate");
x.t("2,3","second");
x.t("2,3","sorts");
x.t("query","example");
x.t("query","results");
x.t("query","limit");
x.t("query","select");
x.t("query","result");
x.t("query","operate");
x.t("query","order");
x.t("query","clause");
x.t("query","individual");
x.t("optional","places");
x.t("optional","allows");
x.t("optional","operators");
x.t("optional","specifies");
x.t("optional","sorts");
x.t("optional","restricts");
x.t("optional","operator");
x.t("temp","creates");
x.t("temp","new_table");
x.t("discard","first");
x.t("discard","rows");
x.t("1.07","column");
x.t("information","subqueries");
x.t("data","type");
x.t("data","types");
x.t("duplicates","returned");
x.t("positioned","number");
x.t("attached","example");
x.t("result","taking");
x.t("result","right");
x.t("result","offset_number");
x.t("result","new_table");
x.t("result","single");
x.t("result","union");
x.t("result","limit");
x.t("result","aggregate");
x.t("result","keeping");
x.t("result","select");
x.t("result","returned");
x.t("result","rows");
x.t("result","query");
x.t("result","result");
x.t("result","contains");
x.t("result","grammar");
x.t("result","negative");
x.t("removing","results");
x.t("examples","example");
x.t("new_emp.deptno","dept.deptno");
x.t("defined","group");
x.t("sort_expression","desc");
x.t("sort_expression","either");
x.t("desc","asc");
x.t("values","counted");
x.t("values","count");
x.t("values","want");
x.t("values","treated");
x.t("values","results");
x.t("values","aggregate");
x.t("values","max");
x.t("values","expressions");
x.t("values","returned");
x.t("values","grouped");
x.t("values","column");
x.t("values","numeric");
x.t("values","special");
x.t("values","except");
x.t("values","separated");
x.t("values","using");
x.t("values","grammar");
x.t("join","user");
x.t("join","dep");
x.t("join","among");
x.t("join","select");
x.t("join","first");
x.t("join","t1.key");
x.t("join","expression");
x.t("join","subquery");
x.t("join","associate");
x.t("join","clause");
x.t("join","table.key");
x.t("intersect","select");
x.t("intersect","[distinct]");
x.t("intersect","optional");
x.t("intersect","operator");
x.t("column_expression","[as]");
x.t("column_expression","simply");
x.t("column_expression","include");
x.t("column_expression","column_expression");
x.t("column_expression","column");
x.t("column_expression","either");
x.t("table_alias","name");
x.t("table_alias","table_name");
x.t("column","alias");
x.t("column","dep");
x.t("column","name");
x.t("column","expressions");
x.t("column","value");
x.t("column","expression");
x.t("column","examples");
x.t("column","values");
x.t("column","column");
x.t("column","names");
x.t("column","descriptive");
x.t("integer","min");
x.t("two","table");
x.t("two","tables");
x.t("two","select");
x.t("two","expressions");
x.t("aggregated","terms");
x.t("offset","example");
x.t("offset","offset_number");
x.t("offset","top");
x.t("offset","number");
x.t("offset","returns");
x.t("offset","operator");
x.t("column_alias","disk");
x.t("column_alias","column_expression");
x.t("column_alias","used");
x.t("numeric","column");
x.t("implicit","example");
x.t("implicit","inner");
x.t("joins","may");
x.t("employees","least");
x.t("employees","department");
x.t("non-aggregate","columns");
x.t("operate","local");
x.t("operate","clause");
x.t("order","last_name");
x.t("order","2,3");
x.t("order","data");
x.t("order","examples");
x.t("order","sort_expression");
x.t("order","clause");
x.t("order","dept_id");
x.t("associate","multiple");
x.t("except","count");
x.t("except","minus");
x.t("except","select");
x.t("except","[distinct]");
x.t("clause","example");
x.t("clause","having");
x.t("clause","indicates");
x.t("clause","places");
x.t("clause","complete");
x.t("clause","group");
x.t("clause","limit");
x.t("clause","place");
x.t("clause","copies");
x.t("clause","select");
x.t("clause","specifies");
x.t("clause","appear");
x.t("clause","subqueries");
x.t("clause","include");
x.t("clause","valid");
x.t("clause","join");
x.t("clause","order");
x.t("clause","clause");
x.t("clause","used");
x.t("clause","sql");
x.t("clause","specify");
x.t("clause","grammar");
x.t("used","refer");
x.t("used","give");
x.t("used","select");
x.t("used","instead");
x.t("used","return");
x.t("used","column");
x.t("used","clause");
x.t("(salary)","200000");
x.t("(salary)","emp");
x.t("(salary)","combination");
x.t("(salary)","returns");
x.t("special","example");
x.t("following","example");
x.t("following","select");
x.t("separated","comma");
x.t("either","name");
x.t("either","explicit");
x.t("either","column");
x.t("either","following");
x.t("links","two");
x.t("dept_id","having");
x.t("dept_id","statement");
x.t("dept_id","sum");
x.t("dept_id","limit");
x.t("individual","select");
x.t("remaining","rows");
x.t("(name)","returns");
x.t("using","left");
x.t("using","count");
x.t("using","union");
x.t("using","operators");
x.t("using","intersect");
x.t("limit_clause","select_clause");
x.t("limit_clause","optional");
x.t("restricts","results");
x.t("terms","groups");
x.t("returns","single");
x.t("returns","sum");
x.t("returns","average");
x.t("returns","minimum");
x.t("returns","number");
x.t("returns","maximum");
x.t("returns","departments");
x.t("returns","row");
x.t("returns","avg");
x.t("asc","sort");
x.t("asc","sort_expression");
x.t("sql","statements");
x.t("sql","expressions");
x.t("sql","expression");
x.t("driver","select");
x.t("operator","precede");
x.t("operator","distinct");
x.t("operator","combines");
x.t("operator","complete");
x.t("operator","union");
x.t("operator","eliminates");
x.t("operator","select");
x.t("operator","specifies");
x.t("operator","added");
x.t("operator","intersect");
x.t("operator","links");
x.t("operator","returns");
x.t("operations","string");
x.t("names","columns");
x.t("names","table");
x.t("names","specified");
x.t("names","prefixed");
x.t("names","subqueries");
x.t("names","constant");
x.t("names","employees");
x.t("names","separated");
x.t("behavior","duplicate");
x.t("behavior","result");
x.t("u.name","myname");
x.t("d.deptname","emp");
x.t("including","rows");
x.t("conditions","rows");
x.t("conditions","groups");
x.t("descriptive","name");
x.t("rel_operator","relational");
x.t("rel_operator","expr2");
x.t("birth_date","person");
x.t("grammar","select_statement");
x.t("grammar","having");
x.t("grammar","expr1");
x.t("grammar","group");
x.t("grammar","limit");
x.t("grammar","table_name");
x.t("grammar","select");
x.t("grammar","order");
x.t("specify","alias");
x.t("specify","list");
x.t("specify","number");
x.t("specify","offset");
x.t("matching","rows");
x.t("table.key","search-condition");
x.t("new_emp","dept");
x.t("contains","rows");
x.t("contains","department");
x.t("item","select");
x.t("negative","number");
}