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.
https://www.tutorialspoint.com/execute_sql_online.php (Links to an external site.)
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers
|Our experts write quality original papers using academic databases.|
|We offer our clients multiple free revisions just to ensure you get what you want.|
|All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount|
|We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity|
|We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay|