Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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:

HDDICRPSFL
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 fileGood 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 fileSatisfactory 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 filePartial 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 fileIncomplete or irrelevant SQL that does not answer the question (

Answered Same Day May 05, 2020

Solution

Ujjawal answered on May 09 2020
139 Votes
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: SELECT * FROM (SELECT * FROM PRODUCT GROUP BY V_CODE HAVING...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here