Question: Hello! I need some help with my MySQL query. I want to find a total shipment cost (sum of all shipments out) of $1156.97 from

Hello! I need some help with my MySQL query.

I want to find a total shipment cost (sum of all shipments out) of $1156.97 from an unknown location (Origin_Location_ID), up to date, from my database.

In other words: Which Origin_Location_ID in my database/table have sent out shipments with a total cost of $1156.97 (so it can be 1, or 20, or 1000 shipments that adds up to this specific sum)

I have following tables:

Shipments table that includes:

Shipment_ID
Origin_Location_ID
Destination_Location_ID
Shipment_Cost (Decimal) (In USD)

Locations :

Location_ID (Integer) (Primary Key)
Location_City
Location_State

Im struggling finding how to write this. How do i get the MySQL to SUM up all the total costs for each location, and find the one who has a total cost of $1156.97 ?

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!

Hello! I really need help with the following exercise.... I have attached 2 documents. 1 with the instruction and another with charts that need to be filled out. Please let me know if you can help!...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

Hello! could you help to find the question number answer? Thank you. Central Manufacturing Entrepreneur Beverly Brown began personally designing and manufacturing fashion accessories in her garage...

Hi tutors, can anyone help me work on the below assignment thanks. Paragraph One & Two: Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. By...

Paragraph One & Two: Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. By 2010, discussions began about whether "cash hoarding" by firms was...

please help with below question as per the attached article on Using Supply Chain Analysis to Examine the Costs of NonTariff Measures (NTMs) : Michael J Ferrantino, WTO 1. Critically examine the...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

Prepare a Statement of Advice (SOA) for the Martins interviewed for Assignment 1. The case study information is attached as a picture at the bottom of the page. As this assignment is to be a SOA for...

1. Could you argue that they were not disabled? 2. But didnt their impairment prevent them from getting the job they wanted?

Below two figures represent the possible two phase microstructures which may be observed in metallic alloy systems. a) In both case the B (Beta) phase is formed in different shapes. In order to...

When individual investors want to buy or sell on the NYSE, they contact their broker who sends the order to a ( n ) Blank _ _ _ _ _ _ or a Blank _ _ _ _ _ _ for presentation to a designated market...

Journalize the following redemption transactions: 1. Oolong Corporation retired $130,000 face value bonds on June 30, 2017, at 103. The carrying value of the bonds at the redemption date was...