Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1. List the item number, description, and price for all items. 2..List all rows and.columns. tor the complete ORDERS table. 3. List the names of customers with.credit limits of $10,000 or more. 4. „List the order pumber for each order placed by.customer pumber 126 on. 10/15/2015. (Hint: Jt you need help,,use the discussion of the DATE data type. in Figure 3-16. in Chapter 3.) 5.. List the number and name of eacb.customer represented by sales rep 30.or.sales rep.45. 6. List the item number and description_of each item that is not in category PZL. 7. List the item number, description. and number of units on band for each item_that has between 20 and 40_units on hand. including both 20 and 40. Do this two ways. 8. List the_item number, description, and on-hand value (units on hand : unit price) of each item in category TOY. (On-band value is really, units on band.".cost, but there is no COST column in the ITEM table.) Assign the name ON_HAND_VALUE to the computed colump. 9. List the item number, description, and on-hand yalue_for each item whose on-hand value is at least $1,500, Assign the name ON_HAND_VALUE to the_computed column. 10. Use the IN operator to list the item number and description of each item in category GME or PZL.

1. List the item number, description, and price for all items. 2..List all rows and.columns. tor the complete ORDERS table. 3. List the names of customers with.credit limits of $10,000 or more. 4. „List the order pumber for each order placed by.customer pumber 126 on. 10/15/2015. (Hint: Jt you need help,,use the discussion of the DATE data type. in Figure 3-16. in Chapter 3.) 5.. List the number and name of eacb.customer represented by sales rep 30.or.sales rep.45. 6. List the item number and description_of each item that is not in category PZL. 7. List the item number, description. and number of units on band for each item_that has between 20 and 40_units on hand. including both 20 and 40. Do this two ways. 8. List the_item number, description, and on-hand value (units on hand : unit price) of each item in category TOY. (On-band value is really, units on band.".cost, but there is no COST column in the ITEM table.) Assign the name ON_HAND_VALUE to the computed colump. 9. List the item number, description, and on-hand yalue_for each item whose on-hand value is at least $1,500, Assign the name ON_HAND_VALUE to the_computed column. 10. Use the IN operator to list the item number and description of each item in category GME or PZL.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

please answer these for me 

Chrome File Edit View History Bookmarks People Tab Window Help Mon Mar 15 9:41 PM 2021SP DBA-120 X b My Questions | b X * TAL Distributors X m Course: 2021SP X E My Library Bryte x A Guide to SQL Mail - Anthonys x + platform.virdocs.com/r/s/0/doc/590707/sp/177630490/mi/568024242?cfi=%2F4%2F4 8 (Update : Welcome to RedShelf eReader! 5371@student Just getting started? Head over to our partner support page for a guide on the basics. Save TAL Distributors Q| 129 Use SQL and the TAL Distributors database (see Figure 1-2 in Chapter 1) to complete the following exercises. If directed to do so by your instructor, use the information proyided with the Chapter 3 Exercises to print your output or save it to a document. 1.. List the item number, description, and price for all items. 2.„List all rows and columns for the_complete ORDERS table. 3. List the names of customers with_credit limits of $10,000 or more. 4. „List the order number for each_order placed by customer number 126 on 10/15/2015. (Hint: If you need help, use the discussion of the DATE data type in Figure 3-16 in Chapter 3.) 5. List the number and name of each customer represented by sales rep 30 or sales rep 45. 6. List the item number and description of each item that is not in category PZĻ. 7. List the item_number, description, and number of units on hand_for each item_that has between 20 and 40 units on hand, including both_20 and 40. Do this two ways. 8. List the item number, description, and on-hand value (units on hand * unit price) of each item in category TOY. (On-hand value is really units on hand * cost, but there is.no COST column in the_ITEM table.) Assign the name ON_HAND_VALUE to the_computed column. 9. List the item number, description, and on-hand value for each item whose on-hand value is at least $1,500. Assign the name ON_HAND_VALUE to the computed column. 10. Use the IN operator to list the item number and description of each item in category GME or PZL. 35,272 MAR 27 15 W A A étv 00
Transcribed Image Text:Chrome File Edit View History Bookmarks People Tab Window Help Mon Mar 15 9:41 PM 2021SP DBA-120 X b My Questions | b X * TAL Distributors X m Course: 2021SP X E My Library Bryte x A Guide to SQL Mail - Anthonys x + platform.virdocs.com/r/s/0/doc/590707/sp/177630490/mi/568024242?cfi=%2F4%2F4 8 (Update : Welcome to RedShelf eReader! 5371@student Just getting started? Head over to our partner support page for a guide on the basics. Save TAL Distributors Q| 129 Use SQL and the TAL Distributors database (see Figure 1-2 in Chapter 1) to complete the following exercises. If directed to do so by your instructor, use the information proyided with the Chapter 3 Exercises to print your output or save it to a document. 1.. List the item number, description, and price for all items. 2.„List all rows and columns for the_complete ORDERS table. 3. List the names of customers with_credit limits of $10,000 or more. 4. „List the order number for each_order placed by customer number 126 on 10/15/2015. (Hint: If you need help, use the discussion of the DATE data type in Figure 3-16 in Chapter 3.) 5. List the number and name of each customer represented by sales rep 30 or sales rep 45. 6. List the item number and description of each item that is not in category PZĻ. 7. List the item_number, description, and number of units on hand_for each item_that has between 20 and 40 units on hand, including both_20 and 40. Do this two ways. 8. List the item number, description, and on-hand value (units on hand * unit price) of each item in category TOY. (On-hand value is really units on hand * cost, but there is.no COST column in the_ITEM table.) Assign the name ON_HAND_VALUE to the_computed column. 9. List the item number, description, and on-hand value for each item whose on-hand value is at least $1,500. Assign the name ON_HAND_VALUE to the computed column. 10. Use the IN operator to list the item number and description of each item in category GME or PZL. 35,272 MAR 27 15 W A A étv 00
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Business Models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS