Queries: 1. Do a query to show name of the resource, building, category and plan to use code for a particular plan to use sode. AND a particular category. 2. Do a query to show all of the fields for a particular building OR a particular category. 3. Do a query to show the id number, the name of the resource, the category, the building, and the plan to use code for records where there is a particular building AND a particular plan to use code OR where there is an id number greater than a certain number AND a particular category. 4. Do a query to show all of the fields for a particular building AND a particular category OR for just a particular plan to use code. 5. Do a query to show all of the fields for a particular building AND either a particular category OR a particular plan to use code. 6. Do a query to show all of the fields for records that meet criteria 1 OR criteria 2 OR criteria 3. You decide what criteria to use. 7. Do a query to show all of the fields for records where the id number is less than a certain amount (you pick the amount) AND either it is in a particular building OR has a particular plan to use code.
Queries: 1. Do a query to show name of the resource, building, category and plan to use code for a particular plan to use sode. AND a particular category. 2. Do a query to show all of the fields for a particular building OR a particular category. 3. Do a query to show the id number, the name of the resource, the category, the building, and the plan to use code for records where there is a particular building AND a particular plan to use code OR where there is an id number greater than a certain number AND a particular category. 4. Do a query to show all of the fields for a particular building AND a particular category OR for just a particular plan to use code. 5. Do a query to show all of the fields for a particular building AND either a particular category OR a particular plan to use code. 6. Do a query to show all of the fields for records that meet criteria 1 OR criteria 2 OR criteria 3. You decide what criteria to use. 7. Do a query to show all of the fields for records where the id number is less than a certain amount (you pick the amount) AND either it is in a particular building OR has a particular plan to use code.
Related questions
Question
Program assignment
Transcribed Image Text:Queries:
1. Do a query to show name of the resource, building, category and plan to use code for a
particular plan to use code AND a particular category.
2. Do a query to show all of the fields for a particular building OR a particular category.
3. Do a query to show the id number, the name of the resource, the category, the building, and the
plan to use code for records where there is a particular building AND a particular plan to use
code OR where there is an id number greater than a certain number AND a particular category.
4. Do a query to show all of the fields for a particular building AND a particular category OR for
just a particular plan to use code.
5.
Do a query to show all of the fields for a particular building AND either a particular category
OR a particular plan to use code.
6. Do a query to show all of the fields for records that meet criteria 1 OR criteria 2 OR criteria 3.
You decide what criteria to use.
7. Do a query to show all of the fields for records where the id number is less than a certain
amount (you pick the amount) AND either it is in a particular building OR has a particular plan
to use code.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
