Display all the columns from the orders table

Assignment Help PL-SQL Programming

Reference no: EM13673275

Problem #1

Display all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in descending order.

Problem #2

Display the CustomerID, and customer's name (show the customer's name as the LastName concatenated to the FirstName separated by a comma and a space). Only show those customers that have the word/partial word "mail" somewhere in the EmailAddress. Order the results by the customer's last name in ascending order.

Problem #3

Display all the LastNames from the Customers table and any associated OrdersIDs from the Orders Table. Show the LastName even if they do not have any associated orders. Order the results by LastName in ascending order.

Problem #4

Display the CustomerID from the Orders table and the sum of the associated ItemPrice multiplied by Quantity using Gross Sales (with a space) as the column name from the OrderItems table. Only show those orders where the Gross Sales is more than $500.00. Display the results in descending order by the gross sales.

Problem #5

Display the LastNames from the Customers table and the OrderIDs from the Orders table for all orders that have a ShipAmount that is greater than the average ShipAmount for all Orders. (**Solve using a subquery).

Reference no: EM13673275

Questions Cloud

The issue of the accounting personnel holding : What other preventions could have been put into place that would have avoided the issue of the accounting personnel holding checks in the bottoms of drawers?

Maximum mass that the particle could possess : Assume there was a process by which two photons, each with momentum 0.5 MeV/c could collide and make a single particle. What is the maximum mass that the particle could possess?

Compute the height of the cliff : Radio waves from a star, of wavelength 247 m, reach a radio telescope by two separate paths. One is a direct path to the receiver, which is situated on the edge of a cliff by the ocean. The second is by reflection off the water.

A string vibrates according to the equation : A string vibrates according to the equation y = 0.5 sin 0.37 x cos 64 t, where x and y are in centimetres and t is in seconds. What is the velocity (in centimetres/second) of the component waves whose superposition can give rise to this vibration?

Display all the columns from the orders table : Display all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in descending order.

What is the capacitance of parallel plate capacitor : The potential dissimilarity between the plates of a parallel plate capacitor is 35 V and the electric field among the plates has strength of 750 V/m. If the plate area is 4.0 × 10-2 m2,what is the capacitance of this capacitor?

Distance of the center of mass of the earth-moon system : The ratio of the mass of the earth to the mass of the moon is 82.6. Suppose that the radius of the earth is about 6494.0 km and that the distance among the center of the earth and the moon is 387319.0 km. Determine the distance of the center of mass..

What is the coefficient of friction among coin and turntable : A coin placed on a turntable rotating at 36.3 rev/min will stay there if its center is placed no further than 10.0 cm from the axis of rotation. What is the maximum distance the center of the coin can be placed from the axis if the turntable rotates ..

Any vector space v satisfies the ten axioms : Any vector space V satisfies the ten axioms - Discuss the importance of this property with one example. Also give a counter case, where it is not satisfied.

User Account

All Pages