Change to use the database frozenfoodAlter table customerOrder add column total as data type decimal size 7,2, not null,default value of 0.0Update table customerOrder, set column total equal to column quantity multiplied bysubquerya. (select column price from table product where column productId in tablecustomerOrder equals column id in table product)Update table customerOrder, set column orderStatelId equal to subquerya. (select column id from table orderstate where state equals “Payment received")Alter table customerPayment add column paymentDate as data type date, not null,default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)Insert into table customerPayment, columns customerOrderId and total result setreturned from querya. Select columns id and total from table customerOrder where columnorderStateld is equal to subqueryi. (select column id from table orderState where column state is equal to"Payment received")Write Test Case 1 as a SQL join query to do the followinga. Select using concatenation of columns firstName and lastName from tablecustomer as Customerb. Select customerOrderld from table customerPavment as "Customer Order"c. Select description from table product as Productd. Select total from table customerOrder as “Product Total"e. Join tables customerPayment, customerOrder, customer, productf. Order by column lastName from table customerAlter table purchaseOrder add column total as data type decimal size 7,2, not null,default value of 0.0Update table purchaseOrder, set column total equal to column quantity multiplied bysubquerya. (select column price from table product where column productld in tablepurchaseOrder equals column id in table product)Insert into table orderstate one row so that column state is equal to 'Payment sent' Determine the total balance owed to each supplier bya. Select column supplierld and SUM(total) from table purchaseOrder andgroup by column supplierIdb. Make note of the supplierId for each supplier whose sum total is greater than$1000i. supplierld:ii. supplierId:iii. supplierId;Update table purchaseOrder, set column orderStateId equal to subquerya. (select column id from table orderstate where state equals "Payment sent")3Alter table supplierTransaction add column pavmentDate as data type date, not null,default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)Insert into table supplierTransaction, columns purchaseOrderld and total result setreturned from querya. Select columns id and total from table purchaseOrder where columnorderStateId is equal to subqueryi. (select column id from table orderState where column state is equal to"Payment sent")Write Test Case 2 as a SQL join query to do the followinga. Select supplierName from table supplier as Supplierb. Select purchaseOrderld from table supplierTransaction as "Purchase Order"c. Select description from table product as Productd. Select total from table purchaseOrder as "Product Total"

Question

Change to use the database frozenfoodAlter table customerOrder add column total as data type decimal size 7,2, not null,default value of 0.0Update table customerOrder, set column total equal to column quantity multiplied bysubquerya. (select column price from table product where column productId in tablecustomerOrder equals column id in table product)Update table customerOrder, set column orderStatelId equal to subquerya. (select column id from table orderstate where state equals “Payment received&#34;)Alter table customerPayment add column paymentDate as data type date, not null,default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)Insert into table customerPayment, columns customerOrderId and total result setreturned from querya. Select columns id and total from table customerOrder where columnorderStateld is equal to subqueryi. (select column id from table orderState where column state is equal to&#34;Payment received&#34;)Write Test Case 1 as a SQL join query to do the followinga. Select using concatenation of columns firstName and lastName from tablecustomer as Customerb. Select customerOrderld from table customerPavment as &#34;Customer Order&#34;c. Select description from table product as Productd. Select total from table customerOrder as “Product Total&#34;e. Join tables customerPayment, customerOrder, customer, productf. Order by column lastName from table customerAlter table purchaseOrder add column total as data type decimal size 7,2, not null,default value of 0.0Update table purchaseOrder, set column total equal to column quantity multiplied bysubquerya. (select column price from table product where column productld in tablepurchaseOrder equals column id in table product)Insert into table orderstate one row so that column state is equal to 'Payment sent' Determine the total balance owed to each supplier bya. Select column supplierld and SUM(total) from table purchaseOrder andgroup by column supplierIdb. Make note of the supplierId for each supplier whose sum total is greater than$1000i. supplierld:ii. supplierId:iii. supplierId;Update table purchaseOrder, set column orderStateId equal to subquerya. (select column id from table orderstate where state equals &#34;Payment sent&#34;)3Alter table supplierTransaction add column pavmentDate as data type date, not null,default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)Insert into table supplierTransaction, columns purchaseOrderld and total result setreturned from querya. Select columns id and total from table purchaseOrder where columnorderStateId is equal to subqueryi. (select column id from table orderState where column state is equal to&#34;Payment sent&#34;)Write Test Case 2 as a SQL join query to do the followinga. Select supplierName from table supplier as Supplierb. Select purchaseOrderld from table supplierTransaction as &#34;Purchase Order&#34;c. Select description from table product as Productd. Select total from table purchaseOrder as &#34;Product Total&#34;

Accepted Answer

Note: As per our guidelines we can able to solve only three questions. So, please re-post the…