SQL
DfeeWeek 5 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
https://www.tutorialspoint.com/execute_sql_online.php
After you have tested your code copy and paste it in a word document and upload it here.
I want after 6h the due at 9am
- 6 years ago
- 10
Purchase the answer to view it
- Order34946.doc
- paraphrasing
- questions
- EDU 635 WK 2
- SCI 230 Week 9 Assignments
- child development class
- answer
- Prof Xavier - Employement Laws Chart
- Describe the balance that you currently seek between career and family life. Do you believe that the mindset of corporate...
- psychology
- essay 2 pages need it in the next 7 hours