In Microsoft SQL,

1) List all rows of the titles table where title column should contain first twenty characters of the title.

2) Select all the titles published by publisher Algodata Infosystems. Use a join to show the result set.

screenshot 2019-02-28 at 19.30 AM Screen Shot 2019-02-28 aL 1.21.46 AM Screen Shot 2019-02-28 1 1.20.21 M job id FK smallint not null E suframe verchar(20) not nul E Phone(enar(12). not null) E address (arhar(40), nul) E city (warchsr20, nu) ord_cate (detetime, not nulC payems ivarchsrl12i, ne: nul) tit ic (PK FK tid[varchan61, not nul E contrect tit, not nul B logo image, nuin storaddress (varchar 40),nuil) E discourtyp(archar(40), net nul) state(ha n E discount (decime4,2) not nul state(chai2, null country arch3, nul) emp id PK empic chan notrul fnamerchan20,nat nul -job id (FK smallint, nat nul E job lvl (tinyirt, null) se pubid FK chanl nct null lorange int, null hirange int, nulC royalty (ntrul) ro , ivaa) lile type(char2,nctn e- pub_id ha. nul) rul