Clicking the link above will take you to the main discussion area, where you will reply to Week 4 discussion.

Clicking the link above will take you to the main discussion area, where you will reply to Week 4 discussion.

Select one of the following SQL statements. You need to identify the statement and the syntax.  Finally, provide an example of the SQL statement.

Please don't replicate a statement that has already been identified. Review the discussion board before submitting your work to see what fellow students have submitted.

• Select with Where clause
• Select with Order by clause
• Select with Group by clause
• Select with Having clause
• Select using (Count (*))
• Insert
• Update using columns
• Update without columns identified
• Delete
• Create Schema
• Create Table
• Create View
• Create Index
• Alter Schema
• Alter Table
• Alter View
• Alter Index
• Drop Schema
• Drop Table
• Drop View
• Drop Index
• Create Trigger (just basic structure) you don't have to provide example with this one
• Create Procedure (just basic structure) you don't have to provide example with this one