Please answer the following questions using SQL show me the answer in SQL if it possible

Heres the SQL code :

CREATE TABLE CUSTOMER( CustomerID Int NOT NULL IDENTITY(1, 1), LastName Char(35) NOT NULL, FirstName Char(25) NOT NULL, Phone Char(12) NULL, EmailAddress VarChar(100) NULL, CONSTRAINT CUSTOMER_PK PRIMARY KEY(CustomerID) );

CREATE TABLE ITEM( ItemNumber Int NOT NULL IDENTITY(1,1), ItemDescription VarChar(255) NOT NULL, Cost Numeric(9,2) NOT NULL, ArtistLastName Char(35) NULL, ArtistFirstName Char(25) NULL, CONSTRAINT ITEM_PK PRIMARY KEY(ItemNumber) );

CREATE TABLE PURCHASE( InvoiceNumber Int NOT NULL IDENTITY (1001,1), InvoiceDate Date NOT NULL, PreTaxAmount Numeric(9,2) NOT NULL, CustomerID Int NOT NULL, CONSTRAINT PURCHASE_PK PRIMARY KEY(InvoiceNumber), CONSTRAINT PURCHASE_CUSTOMER_FK FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID) ON DELETE NO ACTION );

CREATE TABLE PURCHASE_ITEM ( InvoiceNumber Int NOT NULL, InvoiceLineNumber Int NOT NULL, ItemNumber Int NOT NULL, RetailPrice Numeric(9,2) NOT NULL, CONSTRAINT PURCHASE_ITEM_PK PRIMARY KEY(InvoiceNumber, InvoiceLineNumber), CONSTRAINT PURCHASE_ITEM_PURCHASE_FK FOREIGN KEY (InvoiceNumber) REFERENCES PURCHASE(InvoiceNumber) ON DELETE CASCADE, CONSTRAINT PURCHASE_ITEM_ITEM_FK FOREIGN KEY (ItemNumber) REFERENCES ITEM(ItemNumber) ON DELETE NO ACTION );

/***** CUSTOMER DATA ********************************************************/

INSERT INTO CUSTOMER VALUES( 'Stanley', 'Elizabeth','555-236-7789', 'Elizabeth.Stanley@somewhere.com'); INSERT INTO CUSTOMER VALUES( 'Price', 'Fred', '555-236-0091', 'Fred.Price@somewhere.com'); INSERT INTO CUSTOMER VALUES( 'Becky', 'Linda', '555-236-0392', 'Linda.Becky@somewhere.com'); INSERT INTO CUSTOMER VALUES( 'Birch', 'Pamela', '555-236-4493', 'Pamela.Birch@somewhere.com'); INSERT INTO CUSTOMER VALUES( 'Romez', 'Ricardo', '555-236-3334', 'Ricardo.Romez@somewhere.com'); INSERT INTO CUSTOMER VALUES( 'Jackson', 'Samantha', '555-236-1095', 'Samantha.Jackson@somewhere.com');

-- SELECT * FROM CUSTOMER;

/***** ITEM DATA ************************************************************/

INSERT INTO ITEM VALUES('Gold Bracelet', 120.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Gold Necklace', 160.00, 'Baker', 'Samantha'); INSERT INTO ITEM VALUES('Bead Earrings', 50.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Gold Bracelet', 180.00, 'Baker', 'Samantha'); INSERT INTO ITEM VALUES('Silver Necklace', 135.00, 'Baxter', 'Sam'); INSERT INTO ITEM VALUES('Bead Earrings', 25.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Bead Earrings', 22.50, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Gold Earrings', 50.00, 'Lintz', 'John'); INSERT INTO ITEM VALUES('Gold Necklace', 160.00, 'Lintz', 'John'); INSERT INTO ITEM VALUES('Bead Earrings', 20.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Bead Earrings', 35.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Bead Earrings', 45.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Gold Necklace', 225.00, 'Lintz', 'John'); INSERT INTO ITEM VALUES('Silver Earrings', 55.00, 'Lintz', 'John'); INSERT INTO ITEM VALUES('Gold Bracelet', 200.00, 'Lintz', 'John'); INSERT INTO ITEM VALUES('Bead Earrings', 25.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Bead Earrings', 45.00, 'Josephson', 'Mary'); INSERT INTO ITEM VALUES('Gold Bracelet', 210.00, 'Baker', 'Samantha'); INSERT INTO ITEM VALUES('Silver Necklace', 165.00, 'Baxter', 'Sam');

-- SELECT * FROM ITEM;

/***** PURCHASE DATA *******************************************************/

INSERT INTO PURCHASE VALUES('05-MAY-19', 155.00, 1); INSERT INTO PURCHASE VALUES('07-MAY-19', 203.00, 2); INSERT INTO PURCHASE VALUES('11-MAY-19', 75.00, 3); INSERT INTO PURCHASE VALUES('15-MAY-19', 67.00, 4); INSERT INTO PURCHASE VALUES('15-MAY-19', 330.00, 5); INSERT INTO PURCHASE VALUES('16-MAY-19', 25.00, 1); INSERT INTO PURCHASE VALUES('25-MAY-19', 45.00, 3); INSERT INTO PURCHASE VALUES('06-JUN-19', 445.00, 1); INSERT INTO PURCHASE VALUES('07-JUN-19', 72.00, 6);

-- SELECT * FROM PURCHASE;

/***** PURCHASE_ITEM DATA ***************************************************/

INSERT INTO PURCHASE_ITEM VALUES(1001, 1, 1, 155.00); INSERT INTO PURCHASE_ITEM VALUES(1002, 1, 2, 203.00); INSERT INTO PURCHASE_ITEM VALUES(1003, 1, 3, 75.00); INSERT INTO PURCHASE_ITEM VALUES(1004, 1, 6, 35.00); INSERT INTO PURCHASE_ITEM VALUES(1004, 2, 7, 32.00); INSERT INTO PURCHASE_ITEM VALUES(1005, 1, 4, 240.00); INSERT INTO PURCHASE_ITEM VALUES(1005, 2, 8, 90.00); INSERT INTO PURCHASE_ITEM VALUES(1006, 1, 10, 25.00); INSERT INTO PURCHASE_ITEM VALUES(1007, 1, 11, 45.00); INSERT INTO PURCHASE_ITEM VALUES(1008, 1, 5, 175.00); INSERT INTO PURCHASE_ITEM VALUES(1008, 2, 9, 215.00); INSERT INTO PURCHASE_ITEM VALUES(1008, 3, 12, 55.00); INSERT INTO PURCHASE_ITEM VALUES(1009, 1, 14, 72.00);

-- SELECT * FROM PURCHASE_ITEM;

/*********************************************************************************/

Using the James River database, write SQL scripts to answer the following questions: Unless otherwise noted, each script must use a SUBQUERY for credit: 1. Who makes the most expensive necklace and how much is it? (This is a repeat from last week's homework - please use a subquery to answer this one) 2. List the first and last name of each customer who made a purchase in June. 3. List the Artist's First Name, Last Name and Item Description for each item that retails for more than $100. 4. Which customers had invoices less than \$75 PreTaxAmount? 5. List the First and Last Name of each customer who made at least one purchase (invoice) greater than $200. 6. List the Item Description for each item purchased (item with an invoice). 7. Which item numbers were not purchased by anyone? 8. List each Invoice Number along with the Item Description of each item in the order. 9. List each Customer First Name and Last Name who purchased jewelry from Mary Josephson. Use of Sub queries are not necessary for the following: 10. List all the item numbers and their descriptions that cost $50 or more but not over $180. 11. Answer \#9 but this time, use different comparison operators. 12. Create an expression that calculates the labor cost for each item. Name the expression "Cost of Labor". (Hint: Labor cost is 20% of the overall cost of each item) 13. Which customers have more than one invoice