Need answer ASAP Please:
Customer Custld CustName CustAddr CustCity CustState CustZip CustPhone CustIncome C1 jane 123 Any St seattle WA 98105 (303) 524-9286 50000 C2 joe 456 Big Ln bothell WA 98011 (720) 488-0101 75000 Asset Assetld AssetDesc AssetType A1 IBM stock A2 magellan fund A3 microsoft stock Service Servld ServDesc ServRate S1 estate plan $75 S2 portfolio evaluation $50 S3 company research using public websites $25 S4 retirement plan $50 Employee Empld EmpName EmpTitle E1 joe briggs analyst E2 sue monet broker sarah scott supervisor Trade Tradeld Custld Assetld TrdDate TrdQty TrdPrice TrdType TrdStatus T1 C1 A1 2/10/2020 200.00 100.00 buy complete T2 A1 2/11/2020 100.00 150.00 sell complete C1 C2 T3 A2 2/15/2020 50.52 58.22 buy complete T4 C2 A1 2/21/2020 500.00 sell pending T5 C2 A3 2/16/2020 100.00 75.15 buy complete Holding Custld Assetid HoldQty C1 A1 100.00 C2 A2 50.52 C2 A3 100.00 In the following problem statement, what tables appear in the FROM clause? For employee sarah scott, retrieve the customer name and sum of amount paid for charges on estate planning services in February 2020. Asset, Customer, Employee, Trade Customer, Employee, Charge, Price History Customer, Employee, Charge Customer, Employee, Charge, Service Identify the best interpretation for the following SELECT statement. SELECT CustName, AssetType, AssetDesc, TrdDate, TrdPrice * TrdQty as TrdAmt FROM Customer, Trade, Asset WHERE CustState = 'CO' AND TrdDate BETWEEN '1-Feb-2020' AND '29-Feb-2020 AND Customer.Custld = Trade.Custld AND Asset.Assetid = Trade.Assetid AND TrdType = 'buy'; List the customer name, asset type, asset description, trade date, and trade amount of holdings in February 2020 by Colorado customers. List the customer name, asset type, asset description, trade date, and trade amount of trades made in February 2020. List the customer name, asset type, asset description, trade date, and trade amount of buy trades made by Colorado customers. List the customer name, asset type, asset description, trade date, and trade amount of buy trades made in February 2020 by Colorado customers. Write an SQL SELECT statement for the following problem statement. Retrieve the name and income of customers without charges in January 2020. Write an SQL SELECT statement for the following problem statement. Retrieve the customer name, service description, employee name, employee title, charge identifier, charge start time, and charge end time. The result should only include billed charges (ChgBilled = True) with a start time in January 2020. Include a charge even if there is no employee associated with the charge. Write an SQL UPDATE statement for the following problem statement. Update the status of trades to complete for trades executed on October 15, 2020 for customer Jane Smithee. Your statement should have a condition on customer name rather than customer number. Customer Custld CustName CustAddr CustCity CustState CustZip CustPhone CustIncome C1 jane 123 Any St seattle WA 98105 (303) 524-9286 50000 C2 joe 456 Big Ln bothell WA 98011 (720) 488-0101 75000 Asset Assetld AssetDesc AssetType A1 IBM stock A2 magellan fund A3 microsoft stock Service Servld ServDesc ServRate S1 estate plan $75 S2 portfolio evaluation $50 S3 company research using public websites $25 S4 retirement plan $50 Employee Empld EmpName EmpTitle E1 joe briggs analyst E2 sue monet broker sarah scott supervisor Trade Tradeld Custld Assetld TrdDate TrdQty TrdPrice TrdType TrdStatus T1 C1 A1 2/10/2020 200.00 100.00 buy complete T2 A1 2/11/2020 100.00 150.00 sell complete C1 C2 T3 A2 2/15/2020 50.52 58.22 buy complete T4 C2 A1 2/21/2020 500.00 sell pending T5 C2 A3 2/16/2020 100.00 75.15 buy complete Holding Custld Assetid HoldQty C1 A1 100.00 C2 A2 50.52 C2 A3 100.00 In the following problem statement, what tables appear in the FROM clause? For employee sarah scott, retrieve the customer name and sum of amount paid for charges on estate planning services in February 2020. Asset, Customer, Employee, Trade Customer, Employee, Charge, Price History Customer, Employee, Charge Customer, Employee, Charge, Service Identify the best interpretation for the following SELECT statement. SELECT CustName, AssetType, AssetDesc, TrdDate, TrdPrice * TrdQty as TrdAmt FROM Customer, Trade, Asset WHERE CustState = 'CO' AND TrdDate BETWEEN '1-Feb-2020' AND '29-Feb-2020 AND Customer.Custld = Trade.Custld AND Asset.Assetid = Trade.Assetid AND TrdType = 'buy'; List the customer name, asset type, asset description, trade date, and trade amount of holdings in February 2020 by Colorado customers. List the customer name, asset type, asset description, trade date, and trade amount of trades made in February 2020. List the customer name, asset type, asset description, trade date, and trade amount of buy trades made by Colorado customers. List the customer name, asset type, asset description, trade date, and trade amount of buy trades made in February 2020 by Colorado customers. Write an SQL SELECT statement for the following problem statement. Retrieve the name and income of customers without charges in January 2020. Write an SQL SELECT statement for the following problem statement. Retrieve the customer name, service description, employee name, employee title, charge identifier, charge start time, and charge end time. The result should only include billed charges (ChgBilled = True) with a start time in January 2020. Include a charge even if there is no employee associated with the charge. Write an SQL UPDATE statement for the following problem statement. Update the status of trades to complete for trades executed on October 15, 2020 for customer Jane Smithee. Your statement should have a condition on customer name rather than customer number
