Org. Data

my teacher wants us to use www.w3schools.com for this hw question .

• the teacher said if he ask for specific columns, then they should appear in the order he asked
• So if he ask for "last name and first name", then the first column would be the last name, and the second column would be the first name
• end each statement with a semicolon (;)

8.

This SELECT statement should display Nittany, but it displays Nnittany.

SELECT 'N' || LOWER('nItTaNy');

Fix it by using the SUBSTR function. Do not edit 'nItTaNy' by taking away that first 'n'. You must leave that, and fix the SQL by using SUBSTR.