Homework Using MySQL

Anonymous
timer Asked: Oct 2nd, 2017
account_balance_wallet $20

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.

https://www.tutorialspoint.com/execute_sql_online.php (Links to an external site.)Links to an external site.


Tutor Answer

criss53
School: Cornell University

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

BEGIN TRANSACTION;
/* 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 */
INSERT INTO EMPLOYEES VALUES(1,'John',...

flag Report DMCA
Review

Anonymous
Good stuff. Would use again.

Similar Questions
Related Tags

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