Any help on like where to get started on this? I'm just confused.
- The problem statement, all variables and given/known data:
Enter text here.Queries to satisfy these two report requests (use your CCI database):
- Retrieve all rows of active inventory where current on hands is less than minimum level. Create a field in the results that computes the difference between the max and current on hands. Name this field "ReorderQuantity". Include vendor info to make reordering easier. --Hint: see page 110 in the Visual Quickstart textbook.
- Number of all Vendors that are not the preferred vendor that supply products for CategoryId 2. Exclude all disabled products and those introduced into the system prior to 2007.
-
Relevant commands, code, scripts, algorithms:
idk -
The attempts at a solution (include all code and scripts):
dunno, need help start -
Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Kansas State, Manhattan, KS Brian Hucklebee CS146