1 the appropriate sql statements for each query which

Assignment Help Database Management System

Reference no: EM13380361

1. The appropriate SQL statements for each query, which should be copied from your SQL code in MySQL and pasted into your submission file; and

2. Screenshots of the resultant tables which are to be pasted into your submission file immediately after the SQL code for that query. Typing or manually drawing the results is NOT acceptable.

Write SQL SELECT statements to retrieve the following information from the ClassicModels database:

1. Select the product name, scale, vendor and product code for all models of classic cars built between 1948 and 1966. Display the results in order of manufacture.

2. Select the product name, scale, vendor and product code for all models of Vintage cars built before 1930 and with a scale smaller than 1:20. Display the results in order of manufacture.

3. List the South East Asian (excluding Australian and New Zealand) customers of Classic Models. Show their Customer name, city, country, sales Rep name, email address and the sales office that supports them. Order the list by country and city.

4. Which customers cancelled orders, how many different products were in the order and what was the reason for cancellation?

5. Which employees work in a European office? List their office, their full name, their job title, the name and job title of the person that they report to.

6. Which orders over $30,000 in value have been disputed and then later resolved? Who were the customers involved; how many different products were in their order; what was the total value of the disputed order? What was the resolution of the problem?

7. How many models of the Titanic have been shipped? What was the date of the first shipment and when was the last shipment sent?

Reference no: EM13380361

Questions Cloud

A security policy is a statement that partitions the states : a security policy is a statement that partitions the states of the system into a set of authorized or secure states and

Primary task responsenbspwithin the discussion board area : primary task responsenbspwithin the discussion board area write 400-600 words that respond to the following questions

As the lead software engineer for a medium-sized hospital : as the lead software engineer for a medium-sized hospital you have been asked to spearhead an effort to improve the

1 write an application class that contains several : 1 write an application class that contains several methods.nbspthe first method should be named greeting and should

1 the appropriate sql statements for each query which : 1. the appropriate sql statements for each query which should be copied from your sql code in mysql and pasted into

Option 1 you can are required to research into one of the : option 1 you can are required to research into one of the following topics on data security or computer-network

You will need to design an interface to a systemyou will : you will need to design an interface to a system.you will need to justify every item that you choose to put into this

Assessment taskyour task is to develop a java application : assessment taskyour task is to develop a java application that allows the user to read travel booking data from a text

What does the abstract keyword dowhat are generics as they : what does the abstract keyword do?what are generics as they relate to the built in linked list class? why do we need

User Account

All Pages