Using The Coffee Merchant database, you need to create employee commission on sales.
There is a file on Blackboard that walks through this query (f. on Querying Warmup, we did a.-e. in class today). You will need it in order to complete your DPQ on Monday. This is an INDIVIDUAL homework assignment. If you run into problems, email me, I will be around quite a bit the end of this week.
Also, please review the Query Help file which discusses Join Properties and how to use null fields in calculations. Here is a quick video on Joins:
No comments:
Post a Comment