I need help adding these bullets to my SQL file.

• A set of SQL Statements that returns all rows and all data for each table in your database.
• Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.
• Two SQL Statements that join two or more tables in one query.  Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.

create table Artist(

 

        ARTIST_ID number PK,

        Name varchar(50),

        Amount number,

        Address varchar(50),

        Phone varchar(12),

        PRIMARY KEY(ARTIST_ID)

 

);

insert into Artist values(1,'Mike',500,'125 Vista Del Rey', '088 555 6665');

insert into Artist values(2,'Michael',100,'113 laurel lane', '088 223 2335');

insert into Artist values(3,'Richard',200,'124 Phantom Creek', '888 421 2665');

insert into Artist values(4,'Chris',300,'132 Vista Del Rey', '988 222 1145');

insert into Artist values(5,'John',430,'400 Glen Rd', '210 777 2655');

insert into Artist values(6,'Ross',240,'130 Kitty Hawk', '777 553 3333');

insert into Artist values(7,'Taylor',210,'141 Canyon Dr', '555 343 9995');

insert into Artist values(8,'Thomas',300,'169 lakeline Rd', '666 323 2345');

insert into Artist values(9,'Tim',100,'1OO Waskow Ave', '366 313 5225');

insert into Artist values(10,'Pam',180,'145 Sniper Rd', '455 333 2555');

 

create table Art(

 

        ART_ID number PK,

        Cost number,

        Date date,

        Size number,

        Genre varchar(12),

        LOCATION_ID number FK,

        ARTIST_ID number FK,

        PRIMARY KEY(ART_ID),

        FOREIGN KEY (LOCATION_ID) REFERENCES Location(LOCATION_ID),

        FOREIGN KEY (ARTIST_ID) REFERENCES Artist(ARTIST_ID)

        

);

insert into Art values(1,43200,'11-23-2016',45,111,2,3);

insert into Art values(2,400,'01-21-2015',30,222,3,2);

insert into Art values(3,4200,'01-16-2012',32,333,3,1);

insert into Art values(4,45200,'05-18-2017',31,444,4,3);

insert into Art values(5,44202,'05-19-2011',33,555,4,4);

insert into Art values(6,42046,'06-20-2015',36,666,5,8);

insert into Art values(7,1200,'07-29-2019',36,777,5,4);

insert into Art values(8,7200,'04-26-2010',35,888,7,9);

insert into Art values(9,9200,'08-24-2009',25,999,8,5);

insert into Art values(10,9800,'11-23-2021',45,123,9,5);

 

create table Location(

 

        LOCATION_ID number PK,

        Area varchar(50),

        Location varchar(50),

        PRIMARY KEY(LOCATION_ID)

       

);

insert into Location values(1,'East Wing','Texas');

insert into Location values(2,'West Wing','New York');

insert into Location values(3,'South Wing','California');

insert into Location values(4,'North Wing','Maine');

insert into Location values(5,'South Wing','New York');

insert into Location values(6,'West Wing','Alaska');

insert into Location values(7,'East Wing','Washington');

insert into Location values(8,'Noth Wing','Nebraska');

insert into Location values(9,'South Wing','Kansas');

insert into Location values(10,'West Wing','Florida');

APlusGrades

Not Rated (0)

Status NEW Posted 20 Jul 2017 03:07 PM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer