Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Owner\AppData\Roaming\MySQL\Workbench\log\wb.log]
CREATE TABLE Admissions(
Yr INT NOT NULL PRIMARY KEY,
#Apps INT NOT NULL,
#Accepted INT NOT NULL,
#Deposits INT NOT NULL,
#1st Yr INT NOT NULL,
#Transerfers INT NOT NULL,
AvgSAT INT NOT NULL);
SELECT * FROM Admissions;
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES ROW('2012','2900','2600','450','355','80','1235');
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES ('2013','2800','2500','527','402','100','1225');
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES ('2014','3000','2700','413','348','55','1250');
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES('2015','2950','2700','590','422','93','1230');
How to repeat:
CREATE TABLE Admissions(
Yr INT NOT NULL PRIMARY KEY,
#Apps INT NOT NULL,
#Accepted INT NOT NULL,
#Deposits INT NOT NULL,
#1st Yr INT NOT NULL,
#Transerfers INT NOT NULL,
AvgSAT INT NOT NULL);
SELECT * FROM Admissions;
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES ROW('2012','2900','2600','450','355','80','1235');
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES ('2013','2800','2500','527','402','100','1225');
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES ('2014','3000','2700','413','348','55','1250');
INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT)
VALUES('2015','2950','2700','590','422','93','1230');
Description: ----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Owner\AppData\Roaming\MySQL\Workbench\log\wb.log] CREATE TABLE Admissions( Yr INT NOT NULL PRIMARY KEY, #Apps INT NOT NULL, #Accepted INT NOT NULL, #Deposits INT NOT NULL, #1st Yr INT NOT NULL, #Transerfers INT NOT NULL, AvgSAT INT NOT NULL); SELECT * FROM Admissions; INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES ROW('2012','2900','2600','450','355','80','1235'); INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES ('2013','2800','2500','527','402','100','1225'); INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES ('2014','3000','2700','413','348','55','1250'); INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES('2015','2950','2700','590','422','93','1230'); How to repeat: CREATE TABLE Admissions( Yr INT NOT NULL PRIMARY KEY, #Apps INT NOT NULL, #Accepted INT NOT NULL, #Deposits INT NOT NULL, #1st Yr INT NOT NULL, #Transerfers INT NOT NULL, AvgSAT INT NOT NULL); SELECT * FROM Admissions; INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES ROW('2012','2900','2600','450','355','80','1235'); INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES ('2013','2800','2500','527','402','100','1225'); INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES ('2014','3000','2700','413','348','55','1250'); INSERT INTO Admissions (Yr, #Apps, #Accepted, #Deposits, #1st Yr, #Transfers, AvgSAT) VALUES('2015','2950','2700','590','422','93','1230');