July 2, 2013 at 5:58 am
Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’.
Below are the example tables that you will be retrieving data from:
Transactions:
* Sales Order
* Order Quantity
* Order Total
* Order Date
* SalesPersonID
* ProductID
SalesPerson
* SalesPersonID
* SalesPersonName
Product
* ProductID
* ProductName
July 2, 2013 at 6:11 am
the format of your question screams "copy and paste" from your homework;
That's a little frowned upon here, so lets do it right:
can you show us the query you've created so far, and explain what doesn't work, or where you are stuck?
we would love to help you master the problem, rather than do it for you;
you'll suffer later if you don't grasp this concept yourself, because later homework will certain build on top of the basics like this.
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy