I need help with this assignment. Need to create SQL SELECT statements to displa
ID: 3568990 • Letter: I
Question
I need help with this assignment. Need to create SQL SELECT statements to display all the contents of each table sorted in ascending order of its primary key. Need to do this according to the following DDL & DML statements. Please help me. I do not know how to do this one. It would be really helpful for me if you could help me.
DDL
CREATE TABLE Artist(
lastName VARCHAR2(20),
firstName VARCHAR2(15),
interviewDate DATE,
interviewerName VARCHAR2(35),
areaCode CHAR(3),
telephoneNumber CHAR(7),
street VARCHAR2(50),
city VARCHAR2(15),
state CHAR(2),
zip CHAR(5),
salesLastYear NUMBER (8,2),
salesYearToDate NUMBER (8,2),
socialSecurityNumber CHAR(9),
usualMedium VARCHAR(15),
usualStyle VARCHAR(15),
usualType VARCHAR(20),
CONSTRAINT Artist_Lname_Fname_pk PRIMARY KEY (lastName, firstName),
CONSTRAINT Artist_socialSecurityNumber_uk UNIQUE (socialSecurityNumber));
DML
INSERT INTO Artist VALUES('Vincenti', 'Leonardo', '10-Oct-2010', 'Hughes', '212', '5559999','10 Main Street','New York', 'NY','10101', 9000, 4500,'099999876', 'oil', 'realism', 'painting');
INSERT INTO Artist VALUES('Gogh', 'Vincent', '15-Jun-2009', 'Hughes', '914', '5551234','55 West 18 Street','New Rochelle', 'NY', '10801', 9500, 5500,'099999877', 'oil', 'impressionism', 'painting');
INSERT INTO Artist VALUES('Homes','Winslow', '05-Jan-2011', 'Hughes', '619', '1234567','100 Water Street', 'San Diego', 'CA' ,'92101', 14000, 4000,'083999876', 'watercolor', 'realism', 'painting');
INSERT INTO Artist VALUES('Calderone','Alexander', '10-Feb-2009', 'Hughes', '212', '5559999','10 Main Street', 'New York','NY','10101', 20000, 20000,'123999876', 'steel', 'cubism', 'sculpture');
INSERT INTO Artist VALUES('Keefe','Georgia', '05-Oct-2010', 'Hughes', '305', '1239999','5 Chestnut Street', 'Miami', 'FL','33010', 19000, 14500,'987999876', 'oil', 'realism', 'painting');
Explanation / Answer
SELECT *
FROM Artist
ORDER BY Artist_Lname_Fname_pk ASC