1.Write a SELECT statement that returns InvoiceId and Total from the Invoice table. Use the CONCAT function to insert a ‘$’ in the front of the total value — 2.Write a SELECT statement that returns CustomerId and average Total from
1.Write a SELECT statement that returns InvoiceId and Total from the Invoice table. Use the CONCAT function to insert a ‘$’ in the front of the total value — 2.Write a SELECT statement that returns CustomerId and average Total from