Post reply

Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’.

  • July 2, 2013 at 5:58 am

    #279377

    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

    #1629017

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply