Need help for this task:

For the SaleCo database, perform the following SQL queries. For each include a screenshot of the SQL code and the output.

$1.$ Create a list of customers with their first name, last name and customer balance.

$2.$ List all invoices, use the Year and Month functions to find the year and month for each invoice and create new names for these fields.

$3.$ List the distinct area codes for all employees.

$4.$ Create a new field from the product table which shows the new price of the product after the discount is applied.

$5.$ Create a new field that doubles the discount in the Product table and then recalculate the new price of each product.

Here is the DB:

$/*$ Introduction to SQL $*/$

$/*$ Script file for MySQL DBMS $*/$

$/*$ This script file creates the following tables: $*/$

$/*$ VENDOR, PRODUCT, CUSTOMER, INVOICE, LINE $*/$

$/*$ EMPLOYEE, EMP $*/$

$/*$ and loads the default data rows $*/$

BEGIN;

DROP TABLE IF EXISTS LINE ;

DROP TABLE IF EXISTS INVOICE;

DROP TABLE IF EXISTS CUSTOMER;

DROP TABLE IF EXISTS PRODUCT;

DROP TABLE IF EXISTS VENDOR;

DROP TABLE IF EXISTS EMPLOYEE;

DROP TABLE IF EXISTS EMP;

CREATE TABLE VENDOR $($

V$\_$CODE INTEGER,

V$\_$NAME VARCHAR$(35)$ NOT NULL,

V$\_$CONTACT VARCHAR$(15)$ NOT NULL,

V$\_$AREACODE CHAR$(3)$ NOT NULL,

V$\_$PHONE CHAR$(8)$ NOT NULL,

V$\_$STATE CHAR$(2)$ NOT NULL,

V$\_$ORDER CHAR$(1)$ NOT NULL,

PRIMARY KEY $($V$\_$CODE$))$;

CREATE TABLE PRODUCT $($

P$\_$CODE VARCHAR$(10)$ PRIMARY KEY,

P$\_$DESCRIPT VARCHAR$(35)$ NOT NULL,

P$\_$INDATE DATETIME NOT NULL,

P$\_$QOH INTEGER NOT NULL,

P$\_$MIN INTEGER NOT NULL,

P$\_$PRICE NUMERIC$(8,2)$ NOT NULL,

P$\_$DISCOUNT NUMERIC$(4,2)$ NOT NULL,

V$\_$CODE INTEGER,

CONSTRAINT PRODUCT$\_$V$\_$CODE$\_$FK FOREIGN KEY $($V$\_$CODE$)$ REFERENCES VENDOR $($V$\_$CODE$))$;

CREATE TABLE CUSTOMER $($

CUS$\_$CODE INTEGER PRIMARY KEY,

CUS$\_$LNAME VARCHAR$(15)$ NOT NULL,

CUS$\_$FNAME VARCHAR$(15)$ NOT NULL,

CUS$\_$INITIAL CHAR$(1),$

CUS$\_$AREACODE CHAR$(3),$

CUS$\_$PHONE CHAR$(8)$ NOT NULL,

CUS$\_$BALANCE NUMERIC$(9,2)$ DEFAULT $0\mathrm{.}00,$

CONSTRAINT CUS$\_$UI$1$ UNIQUE$($CUS$\_$LNAME,CUS$\_$FNAME, CUS$\_$PHONE$))$;

CREATE TABLE INVOICE $($

INV$\_$NUMBER INTEGER PRIMARY KEY,

CUS$\_$CODE INTEGER NOT NULL,

INV$\_$DATE DATETIME NOT NULL,

CONSTRAINT INVOICE$\_$CUS$\_$CODE$\_$FK FOREIGN KEY $($CUS$\_$CODE$)$ REFERENCES CUSTOMER$($CUS$\_$CODE$))$;

CREATE TABLE LINE $($

INV$\_$NUMBER INTEGER NOT NULL,

LINE$\_$NUMBER NUMERIC$(2,0)$ NOT NULL,

P$\_$CODE VARCHAR$(10)$ NOT NULL,

LINE$\_$UNITS NUMERIC$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

LINE$\_$PRICE NUMERIC$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

PRIMARY KEY $($INV$\_$NUMBER,LINE$\_$NUMBER$),$

FOREIGN KEY $($INV$\_$NUMBER$)$ REFERENCES INVOICE $($INV$\_$NUMBER$)$ ON DELETE CASCADE,

FOREIGN KEY $($P$\_$CODE$)$ REFERENCES PRODUCT$($P$\_$CODE$),$

CONSTRAINT LINE$\_$UI$1$ UNIQUE$($INV$\_$NUMBER, P$\_$CODE$))$;

CREATE TABLE EMPLOYEE $($

EMP$\_$NUM INTEGER PRIMARY KEY,

EMP$\_$TITLE CHAR$(10),$

EMP$\_$LNAME VARCHAR$(15)$ NOT NULL,

EMP$\_$FNAME VARCHAR$(15)$ NOT NULL,

EMP$\_$INITIAL CHAR$(1),$

EMP$\_$DOB DATETIME,

EMP$\_$HIRE$\_$DATE DATETIME,

EMP$\_$YEARS INTEGER,

EMP$\_$AREACODE CHAR$(3),$

EMP$\_$PHONE CHAR$(8))$;

CREATE TABLE EMP $($

EMP$\_$NUM INTEGER PRIMARY KEY,

EMP$\_$TITLE CHAR$(10),$

EMP$\_$LNAME VARCHAR$(15)$ NOT NULL,

EMP$\_$FNAME VARCHAR$(15)$ NOT NULL,

EMP$\_$INITIAL CHAR$(1),$

EMP$\_$DOB DATETIME,

EMP$\_$HIRE$\_$DATE DATETIME,

EMP$\_$AREACODE CHAR$(3),$

EMP$\_$PHONE CHAR$(8),$

EMP$\_$MGR INTEGER$)$;

$/*$ Loading data rows $*/$

$/*$ VENDOR rows $*/$

INSERT INTO VENDOR VALUES$(21225,$'Bryson, Inc.$\text{'},$'Smithson',$\text{'}615\text{'},\text{'}223-3234\text{'},\text{'}$TN$\text{'},\text{'}$Y$\text{'})$;

INSERT INTO VENDOR VALUES$(21226,$'SuperLoo, Inc.$\text{'},$'Flushing',$\text{'}904\text{'},\text{'}215-8995\text{'},\text{'}$FL$\text{'},\text{'}$N$\text{'})$;

INSERT INTO VENDOR VALUES$(21231,\text{'}$D&E Supply' $,$'Singh' $,\text{'}615\text{'},\text{'}228-3245\text{'},\text{'}$TN$\text{'},\text{'}$Y$\text{'})$;

INSERT INTO VENDOR VALUES$(21344,$'Gomez Bros.$\text{'},$'Ortega' $,\text{'}615\text{'},\text{'}889-2546\text{'},\text{'}$KY$\text{'},\text{'}$N$\text{'})$;

INSERT INTO VENDOR VALUES$(22567,$'Dome Supply' $,$'Smith' $,\text{'}901\text{'},\text{'}678-1419\text{'},\text{'}$GA$\text{'},\text{'}$N$\text{'})$;

INSERT INTO VENDOR VALUES$(23119,$'Randsets Ltd$.\text{'},$'Anderson',$\text{'}901\text{'},\text{'}678-3998\text{'},\text{'}$GA$\text{'},\text{'}$Y$\text{'})$;

INSERT INTO VENDOR VALUES$(24004,$'Brackman Bros.$\text{'},$'Browning',$\text{'}615\text{'},\text{'}228-1410\text{'},\text{'}$TN$\text{'},\text{'}$N$\text{'})$;

INSERT INTO VENDOR VALUES$(24288,$'ORDVA, Inc.$\text{'},$'Hakford' $,\text{'}615\text{'},\text{'}898-1234\text{'},\text{'}$TN$\text{'},\text{'}$Y$\text{'})$;

INSERT INTO VENDOR VALUES$(25443,\text{'}$B&K$,$ Inc.$\text{'},$'Smith' $,\text{'}904\text{'},\text{'}227-0093\text{'},\text{'}$FL$\text{'},\text{'}$N$\text{'})$;

INSERT INTO VENDOR VALUES$(25501,$'Damal Supplies' $,$'Smythe' $,\text{'}615\text{'},\text{'}890-3529\text{'},\text{'}$TN$\text{'},\text{'}$N$\text{'})$;

INSERT INTO VENDOR VALUES$(25595,$'Rubicon Systems' $,$'Orton' $,\text{'}904\text{'},\text{'}456-0092\text{'},\text{'}$FL$\text{'},\text{'}$Y$\text{'})$;

$/*$ PRODUCT rows $*/$

INSERT INTO PRODUCT VALUES$(\text{'}11$QER$/31\text{'},$'Power painter, $15$ psi., $3-$nozzle' $,\text{'}2017-11-03\text{'},8,5,109\mathrm{.}99,0\mathrm{.}00,25595)$;

INSERT INTO PRODUCT VALUES$(\text{'}13-$Q$2/$P$2\text{'},\text{'}7\mathrm{.}25-$in$.$ pwr$.$ saw blade' $,\text{'}2017-12-13\text{'},32,15,14\mathrm{.}99,0\mathrm{.}05,21344)$;

INSERT INTO PRODUCT VALUES$(\text{'}14-$Q$1/$L$3\text{'},\text{'}9\mathrm{.}00-$in$.$ pwr$.$ saw blade' $,\text{'}2017-11-13\text{'},18,12,17\mathrm{.}49,0\mathrm{.}00,21344)$;

INSERT INTO PRODUCT VALUES$(\text{'}1546-$QQ$2\text{'},\text{'}$Hrd$.$ cloth, $1/4-$in$.,2$x$50\text{'},\text{'}2018-01-15\text{'},15,8,39\mathrm{.}95,0\mathrm{.}00,23119)$;

INSERT INTO PRODUCT VALUES$(\text{'}1558-$QW$1\text{'},\text{'}$Hrd$.$ cloth, $1/2-$in$.,3$x$50\text{'},\text{'}2018-01-15\text{'},23,5,43\mathrm{.}99,0\mathrm{.}00,23119)$;

INSERT INTO PRODUCT VALUES$(\text{'}2232/$QTY$\text{'},\text{'}$B&D jigsaw, $12-$in$.$ blade'