Homework Help??!!

This is the homework assignment. Am I doing this right?

Q. A nursery maintains a file of all plants in stock. Each record contains the name of a plant, its price, and fields that indicate the plant's light and soil requirements. The light field contains either "sunny," "partial sun," or "shady." The soil field contains either "clay" or "sandy." Only 20 percent of the nursery stock does well in shade, and 50 percent does well in sandy soil. Customers had requested a report that lists the name and price of each plant that would be appropriate in a shady, sandy yard. Consider program efficiency when designing your solution.

I have gotten this far. am I on the right track? Any opinions would be helpful.

thanks,
Amy

 

This is 2 weeks old, do you still require an answer?