my sql

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 the Invoice table grouped by customerId. Use the CONCAT function to insert a ‘$’ in the front of  the average total and the FORMAT function to to display it with commas and 2 decimal places. 

-- 3.  Use the CHAR and CONCAT functions (for the first and last names), to format the the address for each customer in the customer table - the formatted output should look like this

-- Gary Hernandez

-- 3829 Broadway Ave

-- New York, NY 10012 

-- note ***** the output will not look like this in the workbench the CHAR functions will place columns in each row of the results *****

-- 4. Display the first initial, last name, and email address of each customer in the customer table.

-- 5. Return these columns from the customer table, customerid, email and Phone. Use the substr and lpad functions to render the phone number like this: ************9999

-- 6. use the concat_ws function to render to display the customer lastname and firstname in this manner: Lastname, Firstname. Also display the customer's email address but only list the customers whose email addresses have more than 20 characters 

-- 7.Display the customerId and the phone for all customers who live in the USA, format the phone numbers so that they look like this 123-456-7899

-- 8. For every track in the track table, return the track name and the album title. The album title should be in all uppercase letters. 

-- 9. For each track, display the unitprice, unitprice rounded to 1 decimal place, unitprice truncated to 1 decimal place, smallest integer >= unitprice and largest integer <= unitprice. 

-- 10. For each track, display the trackId and a random number between 1 and 10 using the trackId as a seed.