SQL

profileDfee

Week 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

Links to an external site.

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
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      Order34946.doc