This assignmentrequires you to use SQLite to complete the tasks listed below.Student can also use SQL Workbench or another software (if they are familiar) to complete the tasks. For guidance on how to...

1 answer below »


  • This assignmentrequires you to use SQLite to complete the tasks listed below.Student can also use SQL Workbench or another software (if they are familiar) to complete the tasks.

  • For guidance on how to install SQLite, watch this short YouTube video:https://www.youtube.com/watch?v=9ynCDVg54H0

  • For guidance on how to create tables using SQLite, watch this short YouTube video:https://www.youtube.com/watch?v=kij5lPw0F-o

  • Typing the SQL statements or the results is NOT acceptable.

Answered Same DayMay 04, 2020

Answer To: This assignmentrequires you to use SQLite to complete the tasks listed below.Student can also use...

Shunmuga Prabhu answered on May 09 2020
131 Votes
Part A - DML
Query 1:
    SELECT * FROM PRODUCT WHERE P_CODE LIKE '22%';
Query 2:
SELECT * FROM VEN
DOR WHERE V_AREACODE=615;
Query 3:
SELECT CUS_BALANCE FROM CUSTOMER WHERE CUS_LNAME='Williams' AND CUS_FNAME='George';
Query 4:
SELECT V_CODE, COUNT(*) AS NumOfProducts FROM PRODUCT GROUP BY V_CODE HAVING COUNT(*)>2;
Query 5:
SELECT P.V_CODE,V.V_NAME, V.V_PHONE, COUNT(*) AS...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here