Question

write and five outputs of
the quries​

Answer 1

Explanation:

the SQL queries are as follows:

1)select * from MEMBER order by ISSUEDATE desc;

2)select DCODE and DTITLE from DVD where DTYPE="Folk";

3)select DTYPE and count (DTYPE) from DVD;

4) select NAME and ISSUEDATE from MEMBER WHERE ISSUEDATE between 2017-01-01 and 2017-12-31;

Answer 2

Answer:

(i) select * from MEMBER order by ISSUEDATE desc;

(ii) select DCODE,DTITLE FROM DVD WHERE DTYPE='Folk';

(iii) select DTYPE,count(distinct DTYPE) FROM DVD ;

(iv) select NAME,ISSUEDATE  FROM MEMBER WHERE                         ISSUDATE=YEAR(2017);