Discussion Board on Syntax

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

Select with Where clauseSelect with Order by clauseSelect with Group by clauseSelect with Having clauseSelect using (Count (*))InsertUpdate using columnsUpdate without columns identifiedDeleteCreate SchemaCreate TableCreate ViewCreate IndexAlter SchemaAlter TableAlter ViewAlter IndexDrop SchemaDrop TableDrop ViewDrop IndexCreate Trigger (just basic structure) you don’t have to provide example with this oneCreate Procedure (just basic structure) you don’t have to provide example with this one