Question: SELECT s . ShipmentID, s . ContainerType, s . ContainerCount, s . BookingDate, s . SailingDate, s . ArrivalDate, s . CollectionDate FROM Shipment s

SELECT
s.ShipmentID,
s. ContainerType,
s. ContainerCount,
s.BookingDate,
s. SailingDate,
s.ArrivalDate,
s.CollectionDate
FROM Shipment s
JOIN Customer c ON s.CustomerID = c.CustomerID
WHERE c.CustomerName = 'John Watson'
AND EXTRACT (YEAR FROM s.BookingDate)=2021
ORDER BY s.BookingDate; explain the above code ?

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 Programming Questions!

Q:

Assignment Instruction James Morgan owns and operates Morgan Importing, which purchases antiques and home furnishings in Asia, ships those items to a warehouse facility in Los Angeles, and then sells...

Q:

datapaser management system use mysql Morgan Importing purchases antiques and home furnishings in Asia and ships those items to a warehouse facility in Los Angeles. Mr. Morgan uses a database to keep...

Q:

Must create the SQL code that will answer the questions based off of the four tables. A17 fit 1. How much revenue is generated on how many shipments (shipment_id) and weights moved in each quarter...

Q:

James Morgan owns and operates Morgan Importing, which purchases antiques and home furnishings in Asia, ships those items to a warehouse facility in Los Angeles, and then sells these items in the...

Q:

I need help with parts E-H Suppose that you have designed a database for Morgan Importing that has the following tables: EMPLOYEE (EmployeeID, LastName, FirstName, Department, Phone, Fax, STORE...

Q:

hurrry up answer this question INTRODUCTION You will need to create an operational database for an organization. You will need to apply technical skills and using an appropriate tool to create the...

Q:

EMPLOYEE (EmployeeID, LastName, FirstName, Department, Phone, Fax, EmailAddress) STORE (StoreName, City, Country, Phone, Fax, EmailAddress, Contact) ITEM (ItemID, StoreName, PurchasingAgentID,...

Q:

Based on the SHIPMENT table, list the ShipmentID, ShipperName, and ShipperInvoiceNumber of all shippers whose name starts with AB. Based on the ITEM table, show ItemID, Description, Store, and a...

Q:

Assignment Instruction James Morgan owns and operates Morgan Importing, which purchases antiques and home furnishings in Asia, ships those items to a warehouse facility in Los Angeles, and then sells...

Q:

Show the ShipmentID, ShipperName, and DepartureDate of all shipments that have an item with a value of 5,000 or more. Use a join . Present results sorted by ShipperName in ascending order and then...

Q:

Q1) Research and summarize 2-3 types of Contracts that were valid as a matter of Public Policy in the late 1800s early 1900s but would not be accepted today because of our changes in our society Q2)...

Q:

Let T = (V, E) be a rooted tree with root r. Define the relation R on V by x R y, for x, y V, if x = y or if x is on the path from r to y. Prove that R is a partial order.

Q:

From the given set of forces shown in the figure 4 the distance from the origin where the resultant intersects the xaxisdetermine the 1 the magnitude of the resultant force of the system 2 angle that...

Q:

A professor has a large class (250 students) that meets at 9am three days a week. The professor was curious about how eating before an exam affects the students ability to recall information. Before...