Use the School table to create a query that is the schools that have the word Elementary is the names show the school name phone city and state. Order the results by school name Name the quesy Elementary Schocs" (without the quotes) [10 points! Fle CE Dule Die XD Formulate Queries Use the school table to create a query that lists the schools that have the word 'nary in their names and are located is either Derver or are charter schools. Show the school name phone, state and CHARTR Order the results by school name Name the query ementary School Denver or Charter without the quote. Hinttup the criteria for Query to return the schools whe() have "lementary in the name AND are located in Denver O2) elementary in their name AND are a charter school. [10 points 9 AL Yol de Moca P Use the School table to create a query that lists the schools that have the word 'Elementary' in their names and are located in either Denver or are charter schools. Show the school name, phone, city, state and CHARTR. Order the results by school name. Name the query "Elementary Schools Denver or Charter" (without the quotes). Hint: set up the criteria for this query to return those schools who: (1) have "Elementary" in their name AND are located in "Denver" OR (2) have "Elementary" in their name AND are a charter school. [10.5 points) v phone School city School state School CHARTR School Field schoolName Table School Sort Show Criteria or LS S 7 K File Home Create External Data Database Tools Help Assignme Selection of our Copy Al Ascending Al Descending Remove Sort View Pastor Filter Advanced Y Toggle Filter Format Painter Refne All Sort & Filter Views All... Search Clipboard School Query1 School Tables Customer Employee 22 Order Detail Product Refund 95 SaleOrder FE School Y school agencyName schoolName phone street city state ZIP ZIP4 TYPE STATUS ULOCAL LATCOD LONCOD CONAME GSLO GSHI CHARTR BBB hoh Shipment Queries Arizona Cu Denver Hig Foreign Cu Large or Order 3020 Use the School table to create a query that is the schools that have the word Elementary is the names show the school name phone city and state. Order the results by school name Name the quesy Elementary Schocs" (without the quotes) [10 points! Fle CE Dule Die XD Formulate Queries Use the school table to create a query that lists the schools that have the word 'nary in their names and are located is either Derver or are charter schools. Show the school name phone, state and CHARTR Order the results by school name Name the query ementary School Denver or Charter without the quote. Hinttup the criteria for Query to return the schools whe() have "lementary in the name AND are located in Denver O2) elementary in their name AND are a charter school. [10 points 9 AL Yol de Moca P Use the School table to create a query that lists the schools that have the word 'Elementary' in their names and are located in either Denver or are charter schools. Show the school name, phone, city, state and CHARTR. Order the results by school name. Name the query "Elementary Schools Denver or Charter" (without the quotes). Hint: set up the criteria for this query to return those schools who: (1) have "Elementary" in their name AND are located in "Denver" OR (2) have "Elementary" in their name AND are a charter school. [10.5 points) v phone School city School state School CHARTR School Field schoolName Table School Sort Show Criteria or LS S 7 K File Home Create External Data Database Tools Help Assignme Selection of our Copy Al Ascending Al Descending Remove Sort View Pastor Filter Advanced Y Toggle Filter Format Painter Refne All Sort & Filter Views All... Search Clipboard School Query1 School Tables Customer Employee 22 Order Detail Product Refund 95 SaleOrder FE School Y school agencyName schoolName phone street city state ZIP ZIP4 TYPE STATUS ULOCAL LATCOD LONCOD CONAME GSLO GSHI CHARTR BBB hoh Shipment Queries Arizona Cu Denver Hig Foreign Cu Large or Order 3020