Question: Using Teradata ViewPoint Database: db_pvfc11_big 1. List the names the number of products, and the average product price of each product line whose average price

Using Teradata ViewPoint

Database: db_pvfc11_big

1. List the names the number of products, and the average product price of each product line whose average price is greater than $200.

2. List the name of each employee, his or her birth date, the name of his or her manager, and the managers birth date for those employees who were born before their manager was born; label the managers data Manager and ManagerBirth.

3. List each item ordered for order number 1, its standard price, and the total price for each item ordered.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using Teradata ViewPoint Database: db_pvfc11_big 1. List the names the number of products, and the average product price of each product line whose average price is greater than $200. 2. List the...

Using Teradata ViewPoint Database: db_pvfc11_big 1. List all raw materials that are made of cherry and that have dimensions (thickness and width) of 12 by 12. 2. Retrieve the product line ID and the...

SQL Assignment 1 Copy your queries and paste it under each question. Upload the file to the Canvas submission folder. Using Teradata Viewpoint Database: db_pvfc11_big 3. Retrieve the product line ID...

Using Teradata ViewPoint Database: db_pvfc11_big 6. Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4. 7. List the IDs and names of all products that...

Write an SQL query to list product line names and, for each product line, the number of products and the average product price. Include only those product lines the average price of which is higher...

SQL ClassicModels Database Query 1. List product names, product line and the difference between the MSRP and purchase(buy) price of the products. Order the results by product line and the descending...

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

ALL TABLES of pine Valley furniture: CREATE TABLE Customer_T (CustomerID INT NOT NULL, CustomerName VARCHAR(25) , CustomerAddress VARCHAR(30) , CustomerCity VARCHAR(20) , CustomerState CHAR(2) ,...

need question 1-9 and question 13 done Chapter 9 Advanced Query Formulation with SQL 367 2017 2. Using a Type Il nested query, list the customer number, name (first and last), and city of each...

Using the Classic Models database (for the UML model) and Classic Models relation scheme (for the relation scheme model) write the relational algebra statement for the following queries: 1. List the...

Two reservoirs are linked by the system of pipes shown below in Figure Q4. The pipe properties are listed in Table Q4. The water level in Reservoir B is 120 m, while the water level in Reservoir C is...

Draw the Lewis electron dot diagram for each ion. a. Fe2+ b. N3

5 . What type of bond is this? 6 . What is the face value for this bond? 7 . What is the interest rate for this bond? 8 . What is the dollar amount of annual interest for this bond? 9 . When are...

Please answer parts A-G using the information provided. a.What are the implied 1-year forward rates? b.Assume that the pure expectations hypothesis of the term structure is correct. If market...

a lack of participation in decision making and initiative by employees;

too much short-term, situational thinking, and a lack of long-term planning;

Exposure to market forces has focused attention on the cost of human resources as a high proportion of operating costs.