Question: In SQL, 1. Write a SELECT statement that returns these columns from the invoices table : - The invoice_total column - A column that uses
In SQL,
1. 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 a 1 decimal digit - A column that uses the ROUND function to return the invoice total column with NO decimal digits
2. Write a select statement that returns these columns from the date_sample table to 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 seperated by slashes - A column that uses the DATE_FORMAT function to retrun the Start_Date column with its month and day returned as integers with no leading zeros, a two-digit year, and all date parts seperated 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 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 seperated by slashes, and its hours and minutes on a 12-hour clock with an AM/PM indicator.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
