Use the UNION operator to generate a result set consisting o…

Use the UNION operator to generate a result set consisting of two columns from the Vendors table: VendorName and VendorState. Which statement returns the rows for both VendorState = ‘CA’  and VendorState = ‘TX’? A.  SELECT VendorName, VendorState  FROM Vendors  WHERE VendorState = ‘CA’UNION SELECT VendorName, VendorState, ZendorZipCode  FROM Vendors WHERE VendorState ‘TX’;B. SELECT VendorName, VendorState FROM Vendors WHERE VendorState = ‘CA’ UNION SELECT VendorName, VendorState FROM Vendors WHERE VendorState = ‘TX’;  

Which of the following SELECT statements returns three colum…

Which of the following SELECT statements returns three columns from the Invoices table, named Number, Total and Balance where: Number: Column alias for the InvoiceNumber columnTotal: Column alias for the InvoiceTotal columnBalance: InvoiceTotal minus the PaymentTotal, minus the CreditTotal A. SELECT InvoiceNumber, InvoiceTotal, BalanceFROM Invoices;B.SELECT InvoiceNumber, InvoiceTotal, InvoiceTotal – PaymentTotal – CreditTotal AS Number, Total, BalanceFROM Invoices;C.SELECT InvoiceNumber AS Number, InvoiceTotal AS Total, InvoiceTotal + PaymentTotal + CreditTotal AS BalanceFROM Invoices;D.SELECT InvoiceNumber AS Number, InvoiceTotal AS Total,   InvoiceTotal – PaymentTotal – CreditTotal AS BalanceFROM Invoices;