Reference no: EM13192719
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?
|
What would affect equilibrium staff size in open-staff case
: Under the Physicians' cooperative model, if the supply price of physicians were to rise, how would this affect the equilibrium staff size in the open-staff case How would it affect the optimal staff size in the closed-staff case
|
|
Calculate the ionization energy of a hydrogen
: Ionization energy is the energy needed to eject an electron from an atom. Compute the ionization energy of a hydrogen atom in its fourth
|
|
Determine the following diatomic molecules as nonpolar
: Using electronegativity arguments, classify the following diatomic molecules as nonpolar (N), polar (P), or ionic (I). (Use the drop down menus to choose your answers
|
|
Compute the ionization energy
: Ionization energy is the energy needed to eject an electron from an atom or ion. Calculate the ionization energy, IE
|
|
Write sql select statements to retrieve
: How many models of the Titanic have been shipped? What was the date of the first shipment and when was the last shipment sent - Write SQL SELECT statements to retrieve
|
|
Define sunlight consists of photons
: At noon on a clear day, sunlight reaches the earth's surface at Madison, Wisconsin, with an average power of approximately 8.00 kJ·s-1·m-2. If the sunlight consists of photons with an average wavelength of 510.0 nm
|
|
What is the consumer surplus enjoyed by the high demand
: design two packages for the second-degree price discrimination case so that the first package has quantity 8 for the high demand and the second one has quantity 6 for the lower demand such that the low demand group has consumer surplus at least $5..
|
|
Explain what causes the high interest rates in the market
: A number of companies exist that specialize in "payday loans." Payday loans are small loans often for a few hundred dollars or less that are made to low-income borrowers. Often these borrowers have poor credit histories and few assets and would ha..
|
|
What is expected market price if bond market is efficient
: a. If the bond market is efficient, what is the market price of the bond expected to be in one year b. Suppose the bond issuer increases the coupon payment during the year to $30, with the same interest rate and the same current market price, what..
|