The marking criteria for this assignment is:HDDICRPSFLAccurate and elegant SQL that answers all...

Question

The marking criteria for this assignment is: HD DI CR PS FL Accurate and elegant SQL that answers all parts of the question. SQL code copied from SQLite as well as a screen shot of code and results...

1 answer below »

The marking criteria for this assignment is:

HD	DI	CR	PS	FL
Accurate and elegant SQL that answers all parts of the question. SQL code copied from SQLite as well as a screen shot of code and results into the submission file	Good SQL that answers most parts (75% ~ 85%) of the question. SQL code copied from SQLite as well as a screen shot of code and results into the submission file	Satisfactory SQL that answers some parts (65% ~ 75%) of the question. SQL code copied from SQLite as well as a screen shot of code and results into the submission file	Partial SQL that answers a small part (50% ~ 65%) of the question. SQL code copied from SQLite as well as a screen shot of code and results into the submission file	Incomplete or irrelevant SQL that does not answer the question (

tae_636610810269319484_117836_1.png tae_636610810269319484_117836_2.png tae_636610810269319484_117836_3.jpg tae_636610810269319484_117836_4.png

Answered Same Day May 05, 2020

Ujjawal · Accepted Answer

Part A - DML
1. Show the details of the products where the product code starts with ‘22’.
Ans: 
Query: SELECT * FROM PRODUCT WHERE P_CODE LIKE ‘%22’;
2. Display the vendor details from area code 615.
Ans:
Query: SELECT * FROM VENDOR WHERE V_AREACODE =’615’;
3. Find the balance for customer ‘George Williams’.
Ans: 
Query: SELECT CUS_BALANCE FROM CUSTOMER WHERE CUS_FNAME = ‘George’ AND CUS_LNAME = ‘Williams’;
4. Show the number of products from each vendor and display the vendor code if there are more than 2 products from the same vendor.
Ans:
Query:

The marking criteria for this assignment is: HD DI CR PS FL Accurate and elegant SQL that answers all parts of the question. SQL code copied from SQLite as well as a screen shot of code and results...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment