-
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
-
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
-
Forum Rules
|
|