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

Question

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=9ynCDVg54H0For guidance on how to create tables using SQLite, watch this short YouTube video:https://www.youtube.com/watch?v=kij5lPw0F-oTyping the SQL statements or the results is NOT acceptable.

Shunmuga Prabhu · Accepted Answer

Part A - DML
Query 1:
	SELECT * FROM PRODUCT WHERE P_CODE LIKE '22%';
Query 2:
SELECT * FROM VENDOR 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,

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...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment