How to work with data types and
1. Write a SELECT statement that returns four columns based on the InvoiceTotal
column of the Invoices table:
Use the CAST function to return the first column as data type decimal
with 2 digits
How to code subqueries
1. Write a SELECT statement that returns the same result set as this SELECT
statement. Substitute a subquery in a WHERE clause for the inner join.
SELECT DISTINCT VendorName
FROM Vendors JOIN Invoices
CIT111 First Midterm Examination
1. Output from a java programs have been covered in class. Write a line that will output a
message of some type on the screen.
2. Every Java program has four possib