NEED HELP WITH MY MYSQL PROJECT PLEASE:

QUESTION 1) Using the SUBSTRING and CONCAT functions, write a query to display each customer name as a single field in the format Jones, Tom with a heading of Customer along with the customer_phone field in a nicely formatted calculated column named Phone. For example, a record containing the customer_phone value 6145535443 would be output with parentheses, spaces, and hyphens, like this: (614) 555-5443. Sort by last name.

---------------

QUESTION 2)

Create a statement to insert a new record with your values: your customer id, first name, last name, address, city, state, zip code and fax number.

TABLE BELOW: Customer id: 26 Your First Name Your first Name Your Last Name Your last name Your Address Your City Your State Your Zip Code Your Phone Your fax

Note: Use your real name and (9821 Main St, Los Angeles, CA 90001) as your address: Show your INSERT statement along with the results of the following SELECT query to verify that the insert worked correctly.

select * from Customer_T where Customer ID = 26;

----------------

QUESTION 3) . Creates a view that selects every title in the "item" table with a price higher than the average price:

its for mysql project, please do your best with the best answers possible to be correct, thanks