In mySQL

a. Write a SELECT statement that returns these columns from the Invoices table: The invoice total column A column that uses the ROUND function to return the invoice_total column with 1 decimal digit A column that uses the ROUND function to return the invoice_total column with no decimal digits b. Write a SELECT statement that returns these columns from the Date_Sample table in the EX database: The start_date column A column that uses the DATE_FORMAT function to return the start_date column with its month name abbreviated and its month, day, and two-digit year separated by slashes A column that uses the DATE_FORMAT function to return the start_date column with its month and day returned as integers with no leadings zeros, a two-digit year, and all date parts separated by slashes A column that uses the DATE_FORMAT function to return the start_date column with only the hours and minutes on a 12-hour clock with an am/pm indicator A column that uses the DATE_FORMAT function to return the start_date column with its month returned as an integer with no leading zeros, its month, day, and two-digit year separated by slashes, and its hours and minutes on a 12-hour clock with an am/pm indicator c. Write a SELECT statement that returns these columns from the Vendors table: The vendor_name column The vendor_name column in all capital letters The vendor phone column A column that displays the last four digits of each phone number