List the names and the number of shipments

Assignment Help Database Management System

Reference no: EM133055191

Question: Create queries for the following information requests

List the total, average, minimum and maximum distance travelled by each ship

List the total weight of shipments 09-0001 and 11-0002.

List the names and the number of shipments for all captains with more than one shipment. Order the list by the captains' names.

List the total number of shipments for all captains. How many shipments are there for Phillip Levinchuck? Can you validate this?

We wish to see the seasonal trend shipping over the year. List the number of shipments in each month. Ordering the list will show the seasonal trend. List the full name of the month.

Attachment:- Cinema_database.rar

Reference no: EM133055191

Questions Cloud

List how many staff earn more than $30 per hour : List in separate columns the birth month using the full month name, birth day showing the full day name as well as the age.

Operating budget for the upcoming year : We should hire more employees. 2 4567 Draw a diagram for these argyments

Point of view of different sexual orientations : What is your own point of view of different sexual orientations? Do you think women have fewer rights than men?

What is the name of the academic field : What does it mean? What does the term "usability" refer to? What is the name of the academic field?

List the names and the number of shipments : List the names and the number of shipments for all captains with more than one shipment. Order the list by the captains' names

Health care informatics and system breaches : Analyze three ways the HIMS failures impacted the organizations' operations and patient information protection, privacy, or personal safety.

Calculate the net sales revenue for the transaction : Question - Jolly uses the Perpetual Inventory System with Weighted-Average Cost Method. Calculate the Net Sales Revenue for the transaction

List all the employees who were hired before 1982 : Find the average salary for each job type and the number of people employed in each job and List all the employees who were hired before 1982

What is definition of multicultural workforce : What is your definition of multicultural workforce? Provide an example of a good program mission and vision that incorporates the learning needs of a multicultu

User Account

All Pages