Open the file saved in week 4 Search the database to find the following information for your manager. For each search show how you performed the search and the results of the search; the results must show all the fields in the stationary table.
computer science
Description
Open the file saved in week 4 Search the database to find the following information for your manager. For each search show how you performed the search and the results of the search; the results must show all the fields in the stationary table.
1. Find all of the blue stationary items
2. Find all of the black stationary items
3. Find all of the items where the color is not blue
4. Find all of the red items where the discount is ‘yes'
5. Find all of the items where the type contains the word ‘file'
6. Find all of the items where the description contains the word ‘file'
7. Find all of the items with a quantity of less than or equal to 10
8. Find all of the items where the quantity is 10
9. Find all of the items with a quantity of greater than 1
10. Find all of the items with a quantity of greater than or equal to 10
