Solve the business problems using sql, PL-SQL Programming

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server. Output is not required.

1. Display full details for the creditor and purchase order where the order was processed by employee 17 and the word video or the word audio appears in the creditor name.

2. Display the post code and the total number of purchase orders placed with creditors in that post code. Display details for post codes with more than ten orders only.

3. Using a set operator, display the creditor number of all creditors in post code 2220 who have never been paid more than 4000 dollars in a single payment.

4. Display full details for the creditor/s who has received the single largest payment

Posted Date: 3/2/2013 2:17:43 AM | Location : United States







Related Discussions:- Solve the business problems using sql, Assignment Help, Ask Question on Solve the business problems using sql, Get Answer, Expert's Help, Solve the business problems using sql Discussions

Write discussion on Solve the business problems using sql
Your posts are moderated
Related Questions
Equivalences & Rewrite Rules: If notice that as well as allowing us to prove trivial theorems, and tautologies enable us to establish that certain sentences are saying the sam

At times, Brewbean's has changed the id number for existing products. In the past, they have had to add a new product row with the new id to the BB_PRODUCT table, modify all the co

LAWS / RULES - Dollo's Law                     :           Living organisms do exhibit evolutionary irreversibility or evolution is irreversible. Williston's Law

Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Effects of NULL Operator As a general rule-but not a universal one-if NULL is an argument to an invocation of a system-defined read-only operator, then NULL is the result of t

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement