BCS 360 : Lab7 - Programming in SQL
Document Summary
Lab 7: write a select statement that returns these columns from the invoices table: A column named balance that uses the previous three columns to calculate the balance amount and uses the round function to round the result to 2 decimal places select invoicetotal, paymenttotal, credittotal, round(invoicetotal-paymenttotal- Where invoicetotal-paymenttotal-credittotal > 0: write a select statement that returns these columns from the invoices table: A column that returns the four-digit year that"s stored in the invoicedate column. A column that returns only the day of the month that"s stored in the invoicedate column. A column that returns the result from adding thirty days to the invoicedate column select invoicedate, year(invoicedate) as year, day(invoicedate) as day, dateadd(day, 30, Invoicedate) as adding30days from invoices: write a select statement that returns these columns from the invoices table: A column named invoicewarningdate that"s calculated by adding 2 days to the.