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]

5 File Home Create External Data FEE of cul Coor Query Tools 2.mic ...dedication.com Assignment Tasic Database Tools Help Assignment Design Formulate Queries . 2. Ascending Y Selection Now Use the School table to create a query that lists the schools that have the word 'Elementary' in Descar Advanced 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 4. Remove Sort Toggle Site All X Deete 9 "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) School Selection type field Proberties ISNE View Views Sortie Records Clipboard School Query All... * Search General School Tables A Customer hoye u Ordestal Product Refund Alias SOURCE SaleOrder School shome Queries 7 school agency Name schoolName phone street tily state ZID 214 TYPE STATUS VLOCAL LATCOD LONOOD CONAME GSLO GSHI CHARTR Artona cu 1 Denver Ho Foreign Large or a Order 3000 Dricey Prod Southwest phone School city Schaal State School CHARTR School Field school Nene Table School Sort Shan Criteria M ar Ready Nuen Lock TSGL 5 File Home Create External Data FEE of cul Coor Query Tools 2.mic ...dedication.com Assignment Tasic Database Tools Help Assignment Design Formulate Queries . 2. Ascending Y Selection Now Use the School table to create a query that lists the schools that have the word 'Elementary' in Descar Advanced 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 4. Remove Sort Toggle Site All X Deete 9 "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) School Selection type field Proberties ISNE View Views Sortie Records Clipboard School Query All... * Search General School Tables A Customer hoye u Ordestal Product Refund Alias SOURCE SaleOrder School shome Queries 7 school agency Name schoolName phone street tily state ZID 214 TYPE STATUS VLOCAL LATCOD LONOOD CONAME GSLO GSHI CHARTR Artona cu 1 Denver Ho Foreign Large or a Order 3000 Dricey Prod Southwest phone School city Schaal State School CHARTR School Field school Nene Table School Sort Shan Criteria M ar Ready Nuen Lock TSGL