Create an sql query that uses an uncorrelated subquery

Assignment Help PL-SQL Programming

Reference no: EM131411702 , Length: 2

P.S.: As a reminder, your SQL statements should be generic enough to produce proper results EVEN if the data inside the database changes. For example, if I ask you to display the products provided by vendors located in TN, you can't manually extract the V_CODE for vendors in TN and use the results to search table PRODUCT for the corresponding products; instead, your query should be written using a join between the two tables and a WERE clause that include TN or something similar. NOTE: ALL SQL FILES MENTIONED BELOW SHOULD ONLY

INCLUDE SQL COMMANDS IN THEM (NO OUTPUT).

Part 1: Writing More Complex SQL Queries (8 points - 2 points each): Save the SQL code ONLY for the following queries in a single .sql script file called Part1.sql. In addition, include each query (SQL command), along with its corresponding output, in your single report file (Word document please).

1. Create an SQL query that USES AN UNCORRELATED SUBQUERY2 AND NO JOINS3 to display the descriptions for products provided by a vendor in area code 615.

2. Create an SQL query that USES A CORRELATED SUBQUERY to display the descriptions for products provided by a vendor in area code 615 (a join is okay here).

Reference no: EM131411702

Questions Cloud

What are a trade deficit and a trade surplus : What are a trade deficit and a trade surplus? What are the implications of a long-term trade deficit or trade surplus

Discuss the child labor in the carpet weaving industry : You are an attorney hired by EndSlavery Now, a non-governmental agency operating in Pakistan. EndSlaveryNow has been successful in working with multiple governmental and non-governmental sectors (including individuals, industries and international..

Provide concrete construction work : Mo Lambert formed a corporation to provide concrete construction work. His jobs typically involve buildingparking lots, drives, and foundations.

What are the elements of capital budgeting : What are the elements of capital budgeting? How do you determine these elements in the global business arena? Provide examples of how you would use capital budgeting analysis to determine the desirability of global projects

Create an sql query that uses an uncorrelated subquery : Create an SQL query that USES AN UNCORRELATED SUBQUERY2 AND NO JOINS3 to display the descriptions for products provided by a vendor in area code 615.

How the systems operate and how they are interconnected : You are the Lead Controls Engineer for Gniewkowski Engineering Company (GEC), Attached is a Sequence of Operations that gives you a basic idea of how the systems/units operate, and how they are interconnected.

What randomization should be used in given experiment : Explain how this experiment fits the definition of a repeated measures design.- What randomization should be used in this experiment?

What legal authorities may have to be invoked : Drawing on the resources from this Web site and your other Learning Resources this week, address the following questions in a two-page paper: What epidemic control steps do you recommend? What legal authorities may have to be invoked? What factors ..

Write the combinational logic equations : Obtain a ID flip-flop realization for the synchronous sequential circuit specified by the following state table. Use the indicated state assignment. Write the combinational logic equations.

User Account

All Pages