Answered step by step
Verified Expert Solution
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
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 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 weightStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started