This is my homework

please, once you finish, copy them in Notepad ++ file if it is clear.

the website in the bottom is recommended


SQL Homework assignment 1

Create a single table database using the SQL CREATE statement. The table must have at least 10 fields consisting of the following breakdown:

Record ID – numeric (integer)

Four Text fields – two fixed lengths, two variable length

Five numeric fields – two integer, three decimal

After the table has been created insert (using the SQL INSERT statement) at least 8 records with appropriate values to form a consistent data set.

Using the SQL SELECT statement, produce the following data reports.

  • List the entire contents of the database
  • List records that contain a specific field value
  • List records that do not contain a specific value
  • List of records equal to or above a certain value
  • List an aggregation of two of the numeric fields
  • List of records ordered and grouped by value

The following is a good resource to use for this exercise, but you may use any one you wish. (Links to an external site.)Links to an external site.

Looking for solution of this Assignment?


We deliver quality original papers

Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay