Results 1 to 2 of 2

Thread: Please help !!!!!

  1. #1
    Join Date
    Mar 2005
    Posts
    4

    Please help !!!!!

    I am a begineer of SQL.
    Please help me out about SQL statement as below:
    Thank you in advance.

    ----------------------
    The database contains a table named tblProducts which
    currently includes 12,508 records.

    Write the SQL statement to do the following:

    1. Select a list of all products containing the ProdCode and
    ProdDesc fields only.



    2. Select a list of all producrs containing all fields.



    3. Select the product with the highest price and display the
    ProdCode and Price only.



    4. Select the average Price of all the products in the table.


    5. Select all the products with a Price greater than $50.00 and
    place them in order of highest to lowest. Include all fields
    in the selection.



    6. Group the products by Price and count the number of
    products in each Price group. Include the ProdCode, ProdDesc
    and Price.



    7. Select all fields and include all products that have the word
    "BOTTLE" in their ProdDesc.



    8. Select all fields and include all products that begin with the
    word "LARGE" in the ProdDesc field.


    9. Describe the records that will be returned by: SELECT * FROM
    tblProducts ORDER BY PRICE.



    10. Describe the records that will be returned by: SELECT ProdCode,
    ProdDesc FROM tblProducts WHERE PRICE > 155

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    This looks like a homework assignment. You have to learn SQL first. Assignment is very simple.

    Learn sql from sqlcourse.com or sqlcourse2.com

    Please do not post same message in multiple forums in databasejournal.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •