Fruit or Candy category, List details for all Items except

Fruit or Candy category

Assignment Help Basic Computer Science

Reference no: EM134033092

Question

1. List the id , name , city and type for all customers --

2. List the id , name , city and province all customers in Ontario --

3. List the item id , description and category for all items whose quantity on hand is at least 25 but is no more than 75 --

4. List the details for all vegetable (VG) items and who also have a quantity on hand no more than 50.

5. List the details for all items whose type is either Vegetable (VG) or Candy (CD).

6. List the details for all items whose type is either Vegetable (VG) or Fruit (FR) and who also have a Reorder level over 50 --

7. List details for all Items except those whose in the Fruit or Candy category..

8. List the details for all ontario customers. Sequence the output by name within type i.e. type is the major key.

9. List the details for all Credit type customers with a balance over $25. Sequence the output from the highest to lowest balance amount.

10. List the details for all Items whose category is either Fruit or Vegetable, and who also have a quantity on hand below the reorder level.

Reference no: EM134033092

Questions Cloud

About robert floyds all-pairs shortest path algorithm : Which of the following is true about Robert Floyd's all-pairs shortest path algorithm? It determines the minimal costs of the longest processes

Should infants share a bed with their parents : I need help answering " Should infants share a bed with their parents? Why or why not? At what age is bed sharing appropriate?

Details of new students entering a high school : You are writing a program that process the details of new students entering a high school.

Infrastructure management : Explain how your selected framework or standard is relevant to infrastructure management, address how it relates to one or more of the 37 Critical Capabilities

Fruit or Candy category : List details for all Items except those whose in the Fruit or Candy category. List the details for all Items whose category is either Fruit or Vegetable

What strategies may be available to manage these triggers : Describe how the following phtsical triggers contributecto behaviours of older people and what strategies may be available to manage these triggers and behavior

Explain measuring instrument : Define or explain: measuring instrument, examination, test, quiz, item, score, scoring, achievement, measurement and evaluation.

Explain the core functions of the Linux OS : Explain the core functions of the Linux OS that you have chosen. Then compare the differences between your chosen Linux OS distribution and Ubuntu

Research new and upcoming Green Designs : Research new and upcoming Green Designs for any plumbing or electrical system in the residential or commercial arena.

User Account

All Pages