Results 1 to 2 of 2

Thread: Please help !!!!!

  1. #1
    Join Date
    Mar 2005
    Posts
    4

    Please help !!!!!

    I am the begineer of SQL.
    Please help me out these SQL statements.
    Thank you in advance.

    ***************************************

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

    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
  •