HW not done yet

BEGIN TRANSACTION;

/* Create a table called NAMES */

CREATE TABLE Supliers (sId integer PRIMARY KEY, sName varchar , address varchar );

/* Create few records in this table */

INSERT INTO Supliers(sid, sNAME , address) VALUES(101,'ab','ktm');

INSERT INTO Supliers(sid, sNAME , address) VALUES(102,'Lucy','pkhra');

INSERT INTO Supliers(sid, sNAME , address) VALUES(103,'Frank','ktm');

INSERT INTO Supliers(sid, sNAME , address) VALUES(104,'Jane','bhratpur');

INSERT INTO Supliers (sid, sNAME , address)VALUES(105,'Robert','bhartpur');

CREATE TABLE parts (pId integer PRIMARY KEY, pName varchar , color varchar );

/* Create few records in this table */

INSERT INTO parts (pid, pNAME , color) VALUES(201,'break','red');

INSERT INTO parts (pid, pNAME , color) VALUES(202,'break','red');

INSERT INTO parts (pid, pNAME , color) VALUES(203,'fuse','black');

INSERT INTO parts (pid, pNAME , color) VALUES(204,'breakpad','white');

INSERT INTO parts  (pid, pNAME , color)VALUES(205,'enginee','black');

CREATE TABLE catlog (pid integer , sID integer , cost integer );

INSERT INTO catlog (pid, sID , cost) VALUES(201,101,200);

INSERT INTO catlog (pid, sID , cost) VALUES(202,102,300);

INSERT INTO catlog (pid, sID , cost )VALUES(203,105,500);

INSERT INTO catlog (pid, sID , cost )VALUES(204,104,200);

INSERT INTO catlog ( pid, sID , cost)VALUES(205,104,400);

COMMIT;

/* Display all the records from the table */

/* b*/

select sNAME 

from Supliers

where (SELECT parts.color

        FROM parts

        INNER JOIN Supliers ON parts.color = Supliers.sNAME

         where color = 'red')

= 'red';

SELECT parts.color

        FROM parts

        INNER JOIN Supliers ON parts.color = Supliers.sNAME;

/*c*/

select cost*1.2

from catlog;