Change to use the database frozenfood Alter table customerOrder add column total as data type decimal size 7,2, not null, default value of 0.0 Update table customerOrder, set column total equal to...

Extracted text: Change to use the database frozenfood Alter table customerOrder add column total as data type decimal size 7,2, not null, default value of 0.0 Update table customerOrder, set column total equal to column quantity multiplied by subquery a. (select column price from table product where column productId in table customerOrder equals column id in table product) Update table customerOrder, set column orderStatelId equal to subquery a. (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 set returned from query a. Select columns id and total from table customerOrder where column orderStateld is equal to subquery i. (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 following a. Select using concatenation of columns firstName and lastName from table customer as Customer b. Select customerOrderld from table customerPavment as "Customer Order" c. Select description from table product as Product d. Select total from table customerOrder as “Product Total" e. Join tables customerPayment, customerOrder, customer, product f. Order by column lastName from table customer Alter table purchaseOrder add column total as data type decimal size 7,2, not null, default value of 0.0 Update table purchaseOrder, set column total equal to column quantity multiplied by subquery a. (select column price from table product where column productld in table purchaseOrder equals column id in table product) Insert into table orderstate one row so that column state is equal to 'Payment sent'


Extracted text: Determine the total balance owed to each supplier by a. Select column supplierld and SUM(total) from table purchaseOrder and group by column supplierId b. Make note of the supplierId for each supplier whose sum total is greater than $1000 i. supplierld: ii. supplierId: iii. supplierId; Update table purchaseOrder, set column orderStateId equal to subquery a. (select column id from table orderstate where state equals "Payment sent") 3 Alter 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 set returned from query a. Select columns id and total from table purchaseOrder where column orderStateId is equal to subquery i. (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 following a. Select supplierName from table supplier as Supplier b. Select purchaseOrderld from table supplierTransaction as "Purchase Order" c. Select description from table product as Product d. Select total from table purchaseOrder as "Product Total"