Homework Using MySQL

Question Description

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.

Final Answer

Hi! Here is your SQL code.Have a nice day.

/* Create a table called NAMES */
CREATE TABLE EMPLOYEES(Id integer PRIMARY KEY, Name text, age integer,
No_clients integer,
Address VARCHAR(30),
ZipCode CHAR(10), hired_date DATE, salary DECIMAL,
bonus DECIMAL, commission DECIMAL);
/* Create few records in this table */

criss53 (3008)
Cornell University

Top quality work from this tutor! I’ll be back!

It’s my second time using SP and the work has been great back to back :) The one and only resource on the Interwebs for the work that needs to be done!

Thanks, good work


Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors