Need it to be in numerical order. SQL Query14.sql-apmycs4.apsu.edu.EBINION1 (ebinion1 (52))*- Microsoft SQL Server Management Studio Eile

Need it to be in numerical order.

  

Transcribed Image Text:

SQL Query14.sql-apmycs4.apsu.edu.EBINION1 (ebinion1 (52))*- Microsoft SQL Server Management Studio Eile Edit View Query Project Tools Tools Window Help ---New Query 3 X Object Explorer Connect = Inenadovich PEEK OSTEWART30 woodcock1 ANDERSON24 barner1 barnett4 bertram BINION1 EBINION1 Database Diagrams Tables System Tables File Tables Extemal Tables Graph Tables dbo.EMPLOYEE Columns Keys bunch Constraints Triggers Indexes Statistics Edbo.REGION dbo.STORE PK_EMPLOYEE D4F454E8F8D06 Views External Resources Synonyms FK_EMPLOYEE_STORE_4F47C5 Programmability Service Broker Storage Security 7 Ready th nchron - 4x MA 2. Execute= @ 30 33 = SQL Query 16.sql-a...ON1 (ebinion1 (53))* ECREATE TABLE EMPLOYEE EMP CODE CHAR (4) PRIMARY KEY, EMP TITLE VARCHAR (3) NOT NULL, EMP LNAME VARCHAR(15) NOT NULL; EMP FNAME VARCHAR(15) NOT NULL, 100% EMP INITIAL VARCHAR (2) NOT NULL, EMP DOB VARCHAR (15) NOT NULL, STORE CODE CHAR(4), FOREIGN KEY (STORE_CODE) REFERENCES STORE (STORE_CODE) >; SQLQuery14.sql-a...ON1 (ebinion1 (52) XSQLQuery13sql-a...ON1 (ebinion1 (54))* Messages Commande corplated successfully. Completion : 2029-02-26717148158.9335440-08.00 100 % Query executed successfully. un 10 -- Col 3 Ch 3 Quick Launch (Ctrl+Q) SQL Query 10.sql-a...ON1 (ebinion1 (60))* INS P- 6 apmycs4.apsu.edu (14.0 RTM) ebinion1 (52) EBINION1 00:00:00 0 rows SQL Query14.sql-apmycs4.apsu.edu.EBINION1 (ebinion1 (52))*- Microsoft SQL Server Management Studio Eile Edit View Query Project Tools Tools Window Help ---New Query 3 X Object Explorer Connect = Inenadovich PEEK OSTEWART30 woodcock1 ANDERSON24 barner1 barnett4 bertram BINION1 EBINION1 Database Diagrams Tables System Tables File Tables Extemal Tables Graph Tables dbo.EMPLOYEE Columns Keys bunch Constraints Triggers Indexes Statistics Edbo.REGION dbo.STORE PK_EMPLOYEE D4F454E8F8D06 Views External Resources Synonyms FK_EMPLOYEE_STORE_4F47C5 Programmability Service Broker Storage Security 7 Ready th nchron - 4x MA 2. Execute= @ 30 33 = SQL Query 16.sql-a...ON1 (ebinion1 (53))* ECREATE TABLE EMPLOYEE EMP CODE CHAR (4) PRIMARY KEY, EMP TITLE VARCHAR (3) NOT NULL, EMP LNAME VARCHAR(15) NOT NULL; EMP FNAME VARCHAR(15) NOT NULL, 100% EMP INITIAL VARCHAR (2) NOT NULL, EMP DOB VARCHAR (15) NOT NULL, STORE CODE CHAR(4), FOREIGN KEY (STORE_CODE) REFERENCES STORE (STORE_CODE) >; SQLQuery14.sql-a...ON1 (ebinion1 (52) XSQLQuery13sql-a...ON1 (ebinion1 (54))* Messages Commande corplated successfully. Completion : 2029-02-26717148158.9335440-08.00 100 % Query executed successfully. un 10 -- Col 3 Ch 3 Quick Launch (Ctrl+Q) SQL Query 10.sql-a...ON1 (ebinion1 (60))* INS P- 6 apmycs4.apsu.edu (14.0 RTM) ebinion1 (52) EBINION1 00:00:00 0 rows

Answer rating: 100% (QA)

SELECT FROM EMPLOYEE ORDER BY ... View the full answer