SQL statements computer science homework help

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