Number each answer and include both the statement that provides the answer to the question and the output from the statement.
Provide a SQL statement that displays the LASTNAME and FIRSTNAME of each customer separated by a comma. The LASTNAME and FIRSTNAME should be capitalized (ie. JOE should be Joe) and concatenated together with a column alias of "Full Name". The output should be sorted in ascending order by LASTNAME.
Provide a SQL statement that displays the ISBN, TITLE and PROFIT for all books where the COST is greater than or equal to $10.00 and less than or equal to $40.00. (The PROFIT is the difference between RETAIL and COST.) Include only those books that were published since January 1, 2001.
Provide a SQL statement that displays the TITLE and publisher NAME of each book in the "COMPUTER" CATEGORY.
Provide a SQL statement that displays the CUSTOMER# and LASTNAME for each customer along with the ORDER# of any order that the customer placed. The statement should include all customers including those that have not placed any orders.