7. Write a statement to display the shipment ID, average weight and average shipping cost of...
7. Write a statement to display the shipment ID, average weight
and average shipping cost of all shipment items. Group your output
by the shipment ID.
8. Repeat Exercise (7), but restrict your output to records having
average shipping costs in excess of $10.00.
Homework Answers
7. select shipment id, average weight,average shipping cost from (tablename) GROUP BY shipment id
8.select shipment id, average weight,average shipping cost from (tablename) GROUP BY shipment id HAVING average shipping cost>10.00
Add Answer to:
7. Write a statement to display the shipment ID, average weight
and average shipping cost of...
SHIPPING MANIFEST Shipment ID 00-0001 Origin: Destination: Brazil Shipment Date: 01 /10/2010 Expected Arrival: 01/14/2010 Captain: 002-15 Henry Moore Boston Weight Quantity Total WEIGHT Type Des...
SHIPPING MANIFEST Shipment ID 00-0001 Origin: Destination: Brazil Shipment Date: 01 /10/2010 Expected Arrival: 01/14/2010 Captain: 002-15 Henry Moore Boston Weight Quantity Total WEIGHT Type Description Item Number 100 2,000 3223 3297 Concrete Form 500 50,000 174,000 224,000 87 BM Steel Beam Shipment Total: Figure 2: (ref: Modern Database Management, Hoffer et al) Based on figure 2 above: a) Draw a relational schema and show the dependencies on it. (5 marks) b) In what normal form is this relation? Explain...
please Answer c (Cost of Shipment) Although a regional express delivery service bases the charge for shipping a package on the package weight and distance shipped, its profit per package depends...
please Answer c
(Cost of Shipment) Although a regional express delivery service bases the charge for shipping a package on the package weight and distance shipped, its profit per package depends on the package size (volume of space that it occupies) and the size and nature of the load on the delivery truck. The company recently conducted a study to investigate the relationship between the cost, y, of shipment (in dollars) and the variables that control the shipping charge- package...
(TCO 7) Write a JOIN to display the instructor first and last names and the course...
(TCO 7) Write a JOIN to display the instructor first and last names and the course description for the course the instructor is teaching Student Instructor Zipcode PK Student ID PK Instructor ID PK Zip Salutation First Name Last Name Street Address Phone Employer Registration Date Salutation First_Name Last_Name Street Address City State FK1 Zip FK1 Zip Section PK Section ID Course Course Section_Num Enrollment Start Date_Time Location PK Course ID PK,FK1 Section ID PK,FK2 Student ID Capacity FKI |...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” Sort the output by department name and employee title Problem 36, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the number of products within each base and type combination, sorted by base and then by type...
SQL Homework 1. For each reservation, list the reservation ID, trip ID, customer number, and customer...
SQL Homework 1. For each reservation, list the reservation ID, trip ID, customer number, and customer last name. Order the results by customer last name. 2. For each reservation for customer Ryan Goff, list the reservation ID, trip ID, and number of persons. 3. List the trip name of each trip that has Miles Abrams as a guide. 4. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide. 5....
E7-7 Analyzing and Interpreting the Financial Statement Effects of FIFO, LIFO. and Weighted Average Cost Scoresby...
E7-7 Analyzing and Interpreting the Financial Statement Effects of FIFO, LIFO. and Weighted Average Cost Scoresby Inc. tracks the number of units purchased and sold throughout each year but annlies inventory costing method at the end of the year, as if it uses a periodic inventory system. Assum its accounting records provided the following information at the end of the annual accountine period, December 31. LO 7-3 Transactions Units Unit Cost 3,000 $ 8 a. Inventory, Beginning For the year:...
1. Write an Sql statement to display all the columns in the driver table Write an...
1. Write an Sql statement to display all the columns in the driver table Write an SQL statement to display the name, location, and certified for all drivers that have Certified equal to Y. Sort the results in descending order by driverid 3. Write an SQL statement to display the group the data by driverid so we can find the sum of hours and miles logged from timesheet 4. Write an update statement to set the certified to P for...
PYTHON Programming Exercise 2: Create a Simple Cost Calculator Write a program that displays input fields...
PYTHON Programming Exercise 2: Create a Simple Cost Calculator Write a program that displays input fields (item name and cost) and calculates and displays the calculated costs. The program should do the following: Provide data entry areas for item name and cost. Calculate and display the subtotal of all items. Adds a sales tax of 6% and calculate and displays the total cost. Enter the following values into your program. Mother Board $200. RAM $75. Hard Drive $72. Video Graphics...
E7-7 Analyzing and interpreting the Financial Statement Effects of FIFO, LIFO, and Weighted Average Cost [LO...
E7-7 Analyzing and interpreting the Financial Statement Effects of FIFO, LIFO, and Weighted Average Cost [LO 7-3) Scoresby Inc. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year, as it uses a periodic Inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31 Units Cost 1,500 $24 Transactions a. Inventory. Beginning For the year: b. Purchase,...
Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an international shipping business,...
Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an international shipping business, is in the process of assessing the choice between two different cost structures for the business. Option A has relatively higher variable costs per unit shipped but lower annual fixed costs, while Option B has the opposite—relatively lower variable costs in its cost structure but higher fixed costs. Assume that delivery selling prices per unit are constant. The table below contains critical information in...
SHIPPING MANIFEST Shipment ID 00-0001 Origin: Destination: Brazil Shipment Date: 01 /10/2010 Expected Arrival: 01/14/2010 Captain: 002-15 Henry Moore Boston Weight Quantity Total WEIGHT Type Description Item Number 100 2,000 3223 3297 Concrete Form 500 50,000 174,000 224,000 87 BM Steel Beam Shipment Total: Figure 2: (ref: Modern Database Management, Hoffer et al) Based on figure 2 above: a) Draw a relational schema and show the dependencies on it. (5 marks) b) In what normal form is this relation? Explain...
please Answer c
(Cost of Shipment) Although a regional express delivery service bases the charge for shipping a package on the package weight and distance shipped, its profit per package depends on the package size (volume of space that it occupies) and the size and nature of the load on the delivery truck. The company recently conducted a study to investigate the relationship between the cost, y, of shipment (in dollars) and the variables that control the shipping charge- package...
(TCO 7) Write a JOIN to display the instructor first and last names and the course description for the course the instructor is teaching Student Instructor Zipcode PK Student ID PK Instructor ID PK Zip Salutation First Name Last Name Street Address Phone Employer Registration Date Salutation First_Name Last_Name Street Address City State FK1 Zip FK1 Zip Section PK Section ID Course Course Section_Num Enrollment Start Date_Time Location PK Course ID PK,FK1 Section ID PK,FK2 Student ID Capacity FKI |...
E7-7 Analyzing and Interpreting the Financial Statement Effects of FIFO, LIFO. and Weighted Average Cost Scoresby Inc. tracks the number of units purchased and sold throughout each year but annlies inventory costing method at the end of the year, as if it uses a periodic inventory system. Assum its accounting records provided the following information at the end of the annual accountine period, December 31. LO 7-3 Transactions Units Unit Cost 3,000 $ 8 a. Inventory, Beginning For the year:...
1. Write an Sql statement to display all the columns in the driver table Write an SQL statement to display the name, location, and certified for all drivers that have Certified equal to Y. Sort the results in descending order by driverid 3. Write an SQL statement to display the group the data by driverid so we can find the sum of hours and miles logged from timesheet 4. Write an update statement to set the certified to P for...
E7-7 Analyzing and interpreting the Financial Statement Effects of FIFO, LIFO, and Weighted Average Cost [LO 7-3) Scoresby Inc. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year, as it uses a periodic Inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31 Units Cost 1,500 $24 Transactions a. Inventory. Beginning For the year: b. Purchase,...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago