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. 

Select with Where clause
Select with Order by clause

Select with Having clause
Select using (Count (*))

Update using columns
Update without columns identified

Create Schema

Create View

Alter Schema

Alter View
Alter Index

Drop Table

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