Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List all ships that have ever carried rice. List all captains who were captains of shipments that carried rice List all captains who were captains

image text in transcribedList all ships that have ever carried rice.

List all captains who were captains of shipments that carried rice

List all captains who were captains of ships that carried rice. The captain may not necessarily been the captain of the shipment that carried the rice

For each origin, display the origin as well as the number of unique captains who have been captains of shipments which left that port.

shipment shipment id ship no capt id shipment date origin destination arrival _date ship ship no ship class capacity purchase date manufactureid captian capt id license grade fname Iname dob shipment_line shipment id item no quantity manufacture distance manufacture_id name city state rep id bid preference origin destination miles days item item no item type description weight

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions

Question

Provide examples of KPIs in Human Capital Management.

Answered: 1 week ago

Question

What are OLAP Cubes?

Answered: 1 week ago