Using GUIDE in SQL Mode › Creating a Sample Query › A Typical Business Need

A Typical Business Need

Assume you are president of a new manufacturing company and you have been in business for only one month. You want to know how many items have been shipped and how much you can expect to be paid for each group of items. You know your DP department has created a sales history table that lists the items that have been sold and shipped. You decide to create a query to produce the information you need.