A) Prepare a SQL statement to create a table to store multiple field inclusive of text, numbers date and two other fields

B) Insert four records in the table created

C) Prepare a SQL statement to select all fields from the table

D) Develop a query extracting selected fields from the table, the query should retrieve records sorted on a particular field while meeting a single condition

E) Prepare an updated table which increase a field contents by a particular percentage, also your update query should only select a record which meets a particular condition.

F) Extract data using one of the following and/or/not function.

G) Use an aggregate function to extract data from the table that meets a condition.

Answer rating: 100% (QA)

A Create a table to store multiple fields CREATE TABLE YourTableName field1 TEXT field2 INT field3 D... View the full answer