Clayton State University Translating Requirements to SQL Questions

SQL SELECT statements can be challenging to write because many of them must come from a specific word problem. This process is quite commonly defined as a request or a need from the organization. Define three sentences that would reflect a query on an e-commerce database beyond just selecting all of the data from a table. Following are some examples:

• List all of the customers sorted by last name.
• Get the number of orders for the month.
• List all of the products in the category furniture.

Using the sentences, write the SQL SELECT statements that would reflect each particular sentence.